Sony HVR-1500P, 1/2 rack Master series HDV DVCam & DV VTR with SDI out (PAL/NTSC) |
ID : 80 |
Sony HVR-1500P
Don't Pay Too Much !!
Package Deals & Trade-ins Available.
Full Local Warranty & Free Delivery within Australia
Brief Overview:
The HVR-1500 is an HDV source feeder/recorder positioned at the top of the Sony HDV Series. Inheriting the design concept of the market-acclaimed DSR-1500AP, the HVR-1500 offers the same convenient features that professional users demand, such as quick mechanical response, multi-format DV playback and a rich set of professional video/audio interfaces ranging from analogue to digital SDI and AES/EBU.
The HVR-1500 can also be used as a Standard Definition DVCAM recorder, in which case the same editing facilities as the DSR-1500AP are offered.
Features:
Switchable Recording - HDV 1080i/ DVCAM/DV and 60i/50i
The HVR-1500 can be switched between HDV 1080i*, DVCAM and DV (SP)** recording modes, providing full flexibility to record in either standard definition or High Definition depending on your production needs. In addition, it can be switched between 60i and 50i modes, eliminating the need for two separate VTRs, one for each standard.
* In HDV mode, editing capabilities are not available
** The HVR-1500 supports DV (SP) mode only; DV (LP) mode is not available. Assemble or insert editing is not supported in DV (SP) mode.
Playback Compatibility with DV (25 Mb/s) Family Formats
For operational versatility, the HVR-1500 is designed to play back DV (25 Mb/s) family format recorded tapes without a mechanical adaptor and without having to switch playback modes on the menu. DVCPRO 25 recorded tapes (M-size cassettes) can also be played back.
Long Recording Time
The HDV format adopts the same track pitch and tape speed as the DV format, thus offering the same recording time - a maximum of 276 minutes when recording on a PHDV-276DM Digital Master standard cassette tape and 63 minutes when recording on a PHDVM-63DM Digital Master mini cassette tape.
The DVCAM format adopts a wider track pitch than the HDV/DV format (15 micrometers compared to 10 micrometers) and offers a maximum recording time of 184 minutes on a PDV-184N standard cassette tape and 40 minutes on a PDVM- 40N mini cassette tape.
Down-conversion Capability
The HVR-1500 has a built-in downconversion capability that allows 1080i recordings to be output as 480i and 576i signals from the i.LINK and SD-SDI interfaces.
These signals can also be output from the analogue component, composite, or S-Video connectors. This allows 1080i recordings to be edited using non-linear editing systems running DV editing software or to be viewed on an SD monitor.
When down-converting the 1080i recording, the aspect ratio displayed can be converted from 16:9 to 4:3. Display modes can be selected from Squeeze or Edge crop.
HD-SDI Interface
The HVR-1500 provides an HD-SDI output*, capability, through which 1080/60i or 1080/50i HDV recordings can be output in normal playback and search modes. Time code and audio signals are embedded in this HD-SDI output. This interface allows operators to integrate HDV footage and assets easily into existing HD-SDI-based editing systems such as the HDCAM and XDCAM HD systems.
* HDV signals fed to the HVR-1500's i.LINK interface cannot be converted and output from the HD-SDI interface. The i.LINK input signal must be recorded to the HDV tape first. DVCAM/DV playback signals cannot be up-converted for HD-SDI output.
SD-SDI Interface
The HVR-1500 also provides SD-SDI input*/output capability. Time code and audio signals are embedded in the SDI signal. This allows the HVR-1500 to connect with a wide variety of digital equipment including SDI-based editing systems.
* SD-SDI signals fed to the HVR-1500's SD-SDI interface cannot be up-convereted to HDV signals for recording to tape or to HD-SDI signals for output from the HD-SDI interface.
AES/EBU Interface
For professional digital audio needs, the HVR-1500 offers AES/EBU digital audio inputs/outputs.
i.LINK Interface
The HVR-1500 is equipped with a 6-pin i.LINK* interface. This allows it to transfer digital video, audio and command signals (in HDV, DVCAM and DV format) to a compatible VTR or non-linear editing system via just a single cable.
* i.LINK is a trademark of Sony used only to designate that a product contains an IEEE 1394 connector. Not all products with an i.LINK connector will necessarily communicate with each other. For information on compatibility, operating conditions and proper connection, please refer to the documentation supplied with any device with an i.LINK connector. For information on devices that include an i.LINK connection, please contact your nearest Sony office. DVCAM/DV signals fed to the HVR-1500's i.LINK interface cannot be up-converted to HDV signals for recording to tape or to HD-SDI signals for output from the HD-SDI interface.
Analogue Interfaces
As standard, the HVR-1500 provides analogue output interfaces for video and audio. These include composite, component and S-Video (Y/C) outputs and two channels of audio output (via XLR connectors). Using these interfaces, the HVR-1500 can act as a source feeder for an analogue editing system and as a simple playback viewer in various applications such as broadcast station studios, OB vehicles and production offices. By installing the optional HVBK-1505 Analogue Input Board, a full range of analogue video and audio inputs also become available, allowing a smooth transition to digital systems.
RS-422A Control
The HVR-1500 is equipped with an RS-422A interface, which is the industry standard for professional editing. This allows the VTR to interface with other Sony VTRs, editing controllers such as the Sony RM-280 Editing Controller and non-linear editing systems.
The RS-422A offers frame-accurate insert and assemble editing in DVCAM mode. It can also be used for source feeding* in HDV mode.
* The availability of frame-accurate control is dependent on the connected editing controller. For information on compatible editing controllers, please contact your nearest Sony office.
HD and SD Reference Inputs
The HVR-1500 accepts both HD and SD reference signals.
Time Code Input/Output
The HVR-1500 has a time code input/output capability to synchronise time code when making tape copies.
Built-in Signal Generator
Equipped with a built-in signal generator, the HVR-1500 can generate colour bars or black burst for video and a 1-kHz tone or silent signal for audio. These signals can be recorded to tape when the HVR-1500 is operating in DVCAM or DV mode* to create a pre-striped tape prior to editing. They can also be output from the analogue and digital interfaces to adjust other equipment in the system.
* Recording these signals to tapes in the HDV format is not available.
Quick Response Mechanism
Quick mechanical response is an essential requirement for professional video production. The HVR-1500 provides this feature by using a reliable direct reel and drum motor mechanism. Fast forward and rewind speeds are an impressive 85 times normal play speed. In HDV mode, the colour picture search* speeds are ? and ?4 times normal play speed and in DVCAM mode they are between -60 and +60 times normal play speed. In editing environments, where speed and time are critical, this mechanism reduces the frustration editors often feel when they are searching for specific scenes.
*The colour picture search function can be controlled through the RS-422A interface.
Tape and Head Cleaner for Reliable Operation
The HVR-1500 incorporates a tape cleaner that adopts a high-grade sapphire blade. This tape cleaner helps prevent signal dropouts by cleaning away particles that accumulate while the tape is running. The recorder also incorporates a head cleaner to maintain the performance of the drum heads. These cleaners improve the reliability of recording and playback.
Built-in 2.7-inch LCD Monitor
The HVR-1500 is equipped with a 2.7-inch* colour LCD monitor with a high resolution of 211 K dots. This allows operators to view the input source during recording and check the playback picture in a 16:9 widescreen aspect ratio. It can also display the 4-channel audio level meters and time code, as well as setup menus for video, audio and VTR settings. Three different display modes can be selected.
* Viewable area, measured diagonally.
Auto Repeat
The HVR-1500 has a convenient auto repeat function. This enables the VTR to automatically rewind the tape to either the beginning of the tape or to a user-defined index point and to start playback again from there. Repeat start and stop index points can also be defined by setting time code values.
Picture Search (in HDV Mode)
With an editing controller, such as the Sony RM-280 Editing Controller, the HVR-1500 provides a convenient colour picture search function for HDV recordings*.
* In HDV mode, audio jog search is not supported and video jog search is supported in forward mode only.
Picture Search Using Menu Keys
The HVR-1500 provides a picture search function via the menu keys on its front panel. By pressing the relevant keys, forward and reverse search of 8 and 10 times normal play speed is available in HDV and DVCAM/DV modes, respectively. The menu keys also allow frame-by-frame picture search, as well as slow-motion playback.
Assign Button
Functions frequently used for VTR operations can be assigned to an ASSIGN button located on the front panel of the HVR-1500.
Digital Slow Motion and Jog Sound (in DVCAM mode)
When used with an editing controller, such as the Sony RM-280 Editing Controller, the HVR-1500 can provide excellent digital slow motion and jog sound for DVCAM recordings. It offers variable speed playback within the range of -0.5 to +0.5 times normal play speed. This allows operators to locate editing points quickly and accurately using noiseless slowmotion playback pictures.
Audio Level Control
Audio levels can be adjusted via the control knobs on the front panel. In recording mode, the input audio level of the analogue XLR, SD-SDI, AES/EBU and i.LINK* interfaces can be adjusted. In playback mode, the analogue XLR, SD-SDI, HD-SDI, AES/EBU and i.LINK output audio levels can be controlled.
* In HDV mode, the input/output audio levels cannot be adjusted.
Technical Specifications:
Recording/playback performance
Recording format 60i system 1080/60i*, 480/60i* (NTSC)
50i system 1080/50i, 576/50i (PAL)
* 60i indicates a field rate of 59.94Hz
Playback & down conversion
format 60i system 1080/60i*, 480/60i* (NTSC)
50i system 1080/50i, 576/50i (PAL)
* 60i indicates a field rate of 59.94Hz
Tape speed HDV/DV SP
60i system: 18.812 mm/s
50i system: 18.831mm/s
DVCAM
60i system: 28.193 mm/s
50i system: 28.221 mm/s
Playback/recording time HDV/DV SP
Max. 276 min with PHDV-276DM cassette
Max. 63 min with PHDVM-63DM cassette
DVCAM
Max. 184 min with PDV-184N cassette
Max. 40 min with PDVM-40N cassette
Fast forward/rewind time Approx. 3 min with PHDV-276DM and PDV-184N cassette
Video Input
Digital video SD-SDI (BNC x1)
60i system: Conforms to Serial Digital Interface (270Mb/s), SMPTE 259M
50i system: Conforms to Serial Digital Interface (270Mb/s), ITU-R BT. 656
Analog video Ref. video (HD/SD)
60i system
BNC x2, loop-through connection*
HD: bipolar tri-level sync, 0.3 Vp-p, 75ohms, sync negative
SD: black burst or composite sync, 0.286 Vp-p, 75ohms
50i system
BNC x2, loop-through connection*
HD: bipolar tri-level sync, 0.3 Vp-p, 75ohms , sync negative
SD: black burst or composite sync, 0.3 Vp-p, 75ohms, sync negative sync negative
Component**
60i system
BNC x3*
Y: 1.0 Vp-p, 75ohms, sync negative
R-Y: 0.7 Vp-p, 75ohms, (75% colour bars)
B-Y: 0.7 Vp-p, 75ohms, (75% colour bars)
50i system
BNC x3*
Y: 1.0 Vp-p, 75ohms, sync negative
R-Y: 0.7 Vp-p, 75ohms, (100% colour bars)
B-Y: 0.7 Vp-p, 75ohms, (100% colour bars)
Composite**
(BNC x2, loop-through connection)* 1.0 Vp-p, 75ohms, sync negative
*Component, composite, and S-Video inputs share the same BNC connectors.
**The HVBK-1505 Analogue Input Board is required.
Audio Input
Digital audio AES/EBU (BNC x2): Conforms to AES-3id-1995
Analog audio*2 60i system: Audio (XLR 3-pin female x2)
50i system: +4/0/-6 dBu high impedance, balanced
Video Output
Analog video Component (HD) (BNC x3)
Y: 1.0 Vp-p, 75ohms, sync negative
R-Y: 0.7 Vp-p, 75ohms
B-Y: 0.7 Vp-p, 75ohms
Component (SD) (BNC x3)
60i system
Y: 1.0 Vp-p, 75ohms, sync negative
R-Y: 0.7 Vp-p, 75ohms, (75% colour bars)
B-Y: 0.7 Vp-p, 75ohms, (75% colour bars)
50i system
Y: 1.0 Vp-p, 75ohms, sync negative
R-Y: 0.7 Vp-p, 75ohms, (100% colour bars)
B-Y: 0.7 Vp-p, 75ohms, (100% colour bars)
Composite (BNC x1)
1.0 Vp-p, 75ohms, sync negative
S-Video (BNC x2)
60i system
Y: 1.0 Vp-p, 75ohms, sync negative
C: 0.286 Vp-p, 75ohms (at burst level)
50i system
Y: 1.0 Vp-p, ohms, sync negative
C: 0.3 Vp-p, 75ohms (at burst level)
Monitor video (BNC x1)
Composite, 1.0 Vp-p, 75ohms , sync negative, with superimposed text information
Digital video HD-SDI (BNC x2)
Conforms to Serial Digital Interface (1.485, 1.485/1.001 Gb/s), SMPTE 292M
SD-SDI (BNC x2)
60i system: Conforms to Serial Digital Interface (270 Mb/s), SMPTE 259M
50i system: Conforms to Serial Digital Interface (270 Mb/s), ITU-R BT.656
Audio Output
Digital audio AES/EBU (BNC x2) Conforms to AEC-3id-1995
Analog audio Audio (XLR 3-pin male x2)
60i system:
+4/0/-6 dBu, 600 k ohms loading, low impedance balanced
50i system:
+4/0/-3/-6 dBu, 600 k ohms loading, low impedance
Monitor (RCA pin x1)
60i system: -infinity to -11 dBu 卤1 dB (-20 dBFS), 47 k ohms , unbalanced
50i system: -infinity to -9 dBu ? dB (-18 dBFS), 47 k ohms , unbalanced
Headphones (JM-60 jack x1)
60i system:
-infinity to -13 dBu (-20 dBFS), 8 ohms , unbalanced
50i system: -infinity to -11 dBu (-18 dBFS), 8 ohms, unbalanced
i.LINK Interface i.LINK 6-pin x1*5?IEEE 1394-based?o:p>
Time Code Input/Output
TC In BNC x1 0.5 Vp-p to 18 Vp-p, 3.3 k ohms, unbalanced
TC Out BNC x1 2.2 Vp-p ? dB (when 600 ohms terminated), unbalanced
Remote
RS-422A D-sub 9-pin (female) x1
Control-S (SIRCS) Stereo mini jack x1
General
Mass Approx. 6.9 kg (15 lb 3 oz)
Dimensions 211(W) x 130 (H) x 420 (D) mm (8 3/8 x 5 1/8 x16 5/8 inches)
Power requirement AC 100 V to 240 V, 50/60 Hz
Power consumption Approx. 60 W
Operating temperature 5癈 to 40癈 (41癋 to 104癋)
Storage temperature -20癈 to +60癈 (-4癋 to +140癋)
Operating relative humidity Less than 80%
Storage relative humidity Less than 90%
SELECT `data`
FROM `fly9i_session`
WHERE `session_id` = '6aot0g5620okvgm47s2gqnkjs0'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_session | const | PRIMARY | PRIMARY | 602 | const | 1 |
DELETE
FROM `fly9i_session`
WHERE `time` < '1714119469'
SELECT `session_id`
FROM `fly9i_session`
WHERE `session_id` = '6aot0g5620okvgm47s2gqnkjs0'
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_session | const | PRIMARY | PRIMARY | 602 | const | 1 | Using index |
INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`)
VALUES ('6aot0g5620okvgm47s2gqnkjs0', 0, '1714120369')
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
SELECT b.id
FROM fly9i_usergroups AS a
LEFT JOIN fly9i_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
SELECT id, rules
FROM `fly9i_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 |
SELECT folder AS type, element AS name, params
FROM fly9i_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 216 | Using where; Using filesort |
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
SELECT *
FROM `fly9i_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
SELECT `value`
FROM `fly9i_admintools_storage`
WHERE `key` = 'cparams'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_admintools_storage | const | PRIMARY | PRIMARY | 302 | const | 1 |
SHOW TABLES
SHOW FULL COLUMNS
FROM fly9i_acymailing_action
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM fly9i_menu AS m
LEFT JOIN fly9i_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 78 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.m.component_id | 1 | Using where |
SELECT id, home, template, s.params
FROM fly9i_template_styles as s
LEFT JOIN fly9i_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 62 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
SELECT *
FROM fly9i_adsnew_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.1 ms |
Reset for next command | 0.0 ms |
UPDATE `fly9i_extensions`
SET `params` = '{\"mediaversion\":\"6dfaa5089689e88db48074794a35a5d3\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init for update | 0.1 ms |
Updating | 0.1 ms |
End of update loop | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
End of update loop | 0.3 ms |
Query end | 0.0 ms |
Commit | 0.4 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SHOW FULL COLUMNS
FROM `fly9i_content`
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
closing tables | 0.0 ms |
Opening tables | 0.3 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Filling schema table | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
checking permissions | 0.1 ms |
closing tables | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Removing tmp table | 0.1 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.3 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 80
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_ads | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
WHERE `type` = 'component'
AND `element` = 'com_adsnew'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.1 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE a.id = 80
AND adcat.catid IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
1 | SIMPLE | adcat | range | PRIMARY | PRIMARY | 8 | NULL | 22 | Using where; Using index |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.adcat.catid | 1 | |
1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.c.parent | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Sending data | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
UPDATE fly9i_adsnew_ads
SET views = LAST_INSERT_ID(views+1)
WHERE id = 80
Status | Duration |
---|---|
Starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init for update | 0.0 ms |
Updating | 0.1 ms |
End of update loop | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
End of update loop | 0.8 ms |
Query end | 0.0 ms |
Commit | 0.4 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=list%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id
FROM fly9i_menu
WHERE link = 'index.php?option=com_adsnew&view=front'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_positions
WHERE 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_positions | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT f.*
FROM fly9i_adsnew_fields AS f
WHERE f.pos != -1
AND f.published = 1
ORDER by f.posorder
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 13 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.2 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_field_values
ORDER by ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_field_values | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT fieldid,cbfieldvalues
FROM fly9i_adsnew_fields as f
WHERE published = 1
ORDER by f.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 13 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE a.id = 80
AND adcat.catid IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
1 | SIMPLE | adcat | range | PRIMARY | PRIMARY | 8 | NULL | 22 | Using where; Using index |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.adcat.catid | 1 | |
1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.c.parent | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Sending data | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.2 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_fields as f
WHERE f.published = 1
ORDER by f.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 13 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.2 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=edit%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.1 ms |
Reset for next command | 0.0 ms |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fly9i_modules AS m
LEFT JOIN fly9i_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fly9i_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-26 08:32:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 08:32:49')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 470 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | PRIMARY,published,newsfeeds | NO INDEX KEY COULD BE USED | NULL | NULL | 96 | Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | broadcas_2015.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 303 | broadcas_2015.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.4 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.id, c.name,c.parent
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.2 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_comprofiler as cb
ON cb.user_id = a.userid
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE a.published = 1
AND c.published = TRUE
AND c.id IN (22,27)
AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
GROUP BY a.id
ORDER BY a.date_created DESC ,a.id DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | range | PRIMARY | PRIMARY | 4 | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.c.parent | 1 | Using where |
1 | SIMPLE | adcat | index | PRIMARY | PRIMARY | 8 | NULL | 394 | Using where; Using index; Using join buffer (flat, BNL join) |
1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.adcat.adid | 1 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.a.userid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Creating tmp table | 0.1 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 1.2 ms |
Creating sort index | 0.2 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Creating sort index | 0.0 ms |
Removing tmp table | 0.2 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.1 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=details%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=list%'
AND link LIKE '%catid=22%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 95
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_ads | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 78
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_ads | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id, home, template, s.params
FROM fly9i_template_styles as s
LEFT JOIN fly9i_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 62 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT ts.template
FROM fly9i_template_styles AS ts
INNER JOIN fly9i_menu AS m
ON ts.id=m.template_style_id
WHERE m.id = 470
AND m.template_style_id != 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT template
FROM fly9i_template_styles
WHERE home = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_template_styles | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsused_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_acymailing_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_acymailing_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 138 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_acymailing_list | system | typeorderingindex,typeuseridindex | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 23
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 6
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 7
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 22
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 8
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 18
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 29
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT `params`
FROM `fly9i_comprofiler_plugin`
WHERE `id` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_comprofiler_plugin | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SHOW FULL COLUMNS
FROM `fly9i_users`
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
closing tables | 0.0 ms |
Opening tables | 0.3 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Filling schema table | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
checking permissions | 0.1 ms |
closing tables | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Removing tmp table | 0.1 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT f.*
FROM fly9i_comprofiler_fields f
INNER JOIN fly9i_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
WHERE f.published = 1
ORDER BY t.position, t.ordering, f.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | f | ALL | tabid_pub_prof_order | NO INDEX KEY COULD BE USED | NULL | NULL | 36 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.f.tabid | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `fly9i_comprofiler_plugin`
WHERE `published` = 1
AND `viewaccesslevel` IN (1)
AND `type` = 'user'
ORDER BY `ordering`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_comprofiler_plugin | ref | type_pub_order,idx_folder | type_pub_order | 304 | const,const | 6 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT `id`
FROM `fly9i_menu`
WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
AND `published` = 1
AND `access` IN ( 1 )
AND `language` IN ( 'en-GB', '*', '' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
WHERE 1
AND c.published = 1
and a.published = 1
GROUP BY a.id
ORDER BY a.ad_featureditem DESC, a.id DESC
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | index | PRIMARY | PRIMARY | 4 | NULL | 323 | Using where; Using temporary; Using filesort |
1 | SIMPLE | adcat | ref | PRIMARY | PRIMARY | 4 | broadcas_2015.a.id | 1 | Using index |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.adcat.catid | 1 | Using where |
1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.c.parent | 1 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.a.userid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting for group | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 7.4 ms |
Creating sort index | 1.0 ms |
Removing tmp table | 4.7 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=details%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=list%'
AND link LIKE '%catid=24%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsnew_categories
WHERE id = 24
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT ad_headline
FROM fly9i_adsnew_ads
WHERE id = 471
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_ads | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
Updating status | 0.0 ms |
Storing result in query cache | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsused_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsused_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 27 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsused_ads as a
INNER JOIN fly9i_adsused_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsused_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsused_categories as p
ON c.parent = p.id
WHERE 1
AND c.published = 1
and a.published = 1
GROUP BY a.id
ORDER BY a.ad_featureditem DESC, a.id DESC
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | adcat | index | PRIMARY | PRIMARY | 8 | NULL | 1302 | Using index; Using temporary; Using filesort |
1 | SIMPLE | c | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.adcat.catid | 1 | Using where |
1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.c.parent | 1 | Using where |
1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.adcat.adid | 1 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | broadcas_2015.a.userid | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsused&view=details%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsused&view=list%'
AND link LIKE '%catid=13%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id
FROM fly9i_menu
WHERE link = 'index.php?option=com_adsused&view=front'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT name
FROM fly9i_adsused_categories
WHERE id = 13
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_categories | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT ad_headline
FROM fly9i_adsused_ads
WHERE id = 1799
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsused_ads | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_adsnew_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_adsnew_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT group_id
FROM fly9i_user_usergroup_map
WHERE user_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_user_usergroup_map | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE 1
ORDER BY c.parent,c.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT c.*
FROM fly9i_adsnew_categories as c
WHERE c.published = 1
AND c.id IN (6,18,37,39,9,10,8,29,25,34,38,21,22,36,16,17,24,23,27,35,28,7)
ORDER BY c.parent,c.ordering,c.id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | c | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id,language
FROM fly9i_menu
WHERE link LIKE '%option=com_adsnew&view=result%'
AND published ='1'
AND type ='component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 148 | Using where |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SHOW FULL COLUMNS
FROM `fly9i_template_styles`
Status | Duration |
---|---|
Starting | 0.0 ms |
checking permissions | 0.0 ms |
closing tables | 0.0 ms |
Opening tables | 0.3 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Filling schema table | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
checking permissions | 0.1 ms |
closing tables | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Removing tmp table | 0.1 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM fly9i_template_styles
WHERE `id` = '10'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | fly9i_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking privileges on cached | 0.0 ms |
checking permissions | 0.0 ms |
Sending cached result to clien | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
UPDATE `fly9i_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714120369;s:18:\"session.timer.last\";i:1714120369;s:17:\"session.timer.now\";i:1714120369;s:24:\"session.client.forwarded\";s:12:\"3.139.238.76\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1714120369'
WHERE `session_id` = '6aot0g5620okvgm47s2gqnkjs0'
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init for update | 0.1 ms |
Updating | 0.1 ms |
End of update loop | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.4 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
13 × SELECT name
FROM fly9i_adsnew_categories
10 × SELECT name
FROM fly9i_adsused_categories
9 × SELECT c.*
FROM fly9i_adsnew_categories as c
9 × SELECT id,language
FROM fly9i_menu
7 × SELECT group_id
FROM fly9i_user_usergroup_map
5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM fly9i_extensions
5 × SELECT *
FROM fly9i_adsnew_confi
4 × SELECT ad_headline
FROM fly9i_adsnew_ads
4 × SELECT `id`
FROM `fly9i_menu`
2 × SELECT *
FROM fly9i_adsnew_categories
2 × SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
2 × SELECT id, home, template, s.params
FROM fly9i_template_styles as s
LEFT JOIN fly9i_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
2 × SELECT *
FROM fly9i_adsused_confi
2 × SELECT id
FROM fly9i_menu
1 × SELECT ts.template
FROM fly9i_template_styles AS ts
INNER JOIN fly9i_menu AS m
ON ts.id=m.template_style_id
1 × SELECT template
FROM fly9i_template_styles
1 × SELECT *
FROM fly9i_acymailing_confi
1 × SELECT `params`
FROM `fly9i_comprofiler_plugin`
1 × SELECT *
FROM fly9i_acymailing_list
1 × SELECT f.*
FROM fly9i_comprofiler_fields f
INNER JOIN fly9i_comprofiler_tabs AS t
ON (f.tabid = t.tabid)
1 × SELECT ad_headline
FROM fly9i_adsused_ads
1 × SELECT *
FROM fly9i_template_styles
1 × SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsused_ads as a
INNER JOIN fly9i_adsused_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsused_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsused_categories as p
ON c.parent = p.id
1 × SELECT c.*
FROM fly9i_adsused_categories as c
1 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
FROM `fly9i_comprofiler_plugin`
1 × SELECT a.*,p.id as parentid,p.name as parent,c.id as catid, c.name as cat,u.username as user
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
1 × SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname
FROM fly9i_adsnew_ads as a
INNER JOIN fly9i_adsnew_adcat as adcat
ON adcat.adid = a.id
LEFT JOIN fly9i_comprofiler as cb
ON cb.user_id = a.userid
LEFT JOIN fly9i_users as u
ON a.userid = u.id
INNER JOIN fly9i_adsnew_categories as c
ON adcat.catid = c.id
LEFT JOIN fly9i_adsnew_categories as p
ON c.parent = p.id
1 × SELECT f.*
FROM fly9i_adsnew_fields AS f
1 × SELECT *
FROM `fly9i_admintools_wafexceptions`
1 × SELECT `value`
FROM `fly9i_admintools_storage`
1 × SELECT folder AS type, element AS name, params
FROM fly9i_extensions
1 × SELECT id, rules
FROM `fly9i_viewlevels
1 × SELECT `session_id`
FROM `fly9i_session`
1 × SELECT b.id
FROM fly9i_usergroups AS a
LEFT JOIN fly9i_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM fly9i_menu AS m
LEFT JOIN fly9i_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT *
FROM fly9i_languages
1 × SELECT *
FROM fly9i_adsnew_fields as f
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fly9i_modules AS m
LEFT JOIN fly9i_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fly9i_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT fieldid,cbfieldvalues
FROM fly9i_adsnew_fields as f
1 × SELECT *
FROM fly9i_adsnew_field_values
1 × SELECT *
FROM fly9i_adsnew_positions
1 × SELECT `data`
FROM `fly9i_session`
1 × SELECT c.id, c.name,c.parent
FROM fly9i_adsnew_categories as c
1 × UPDATE fly9i_adsnew_ads
SET views = LAST_INSERT_ID(views+1)
1 × SHOW FULL COLUMNS
FROM `fly9i_users
1 × SHOW FULL COLUMNS
FROM `fly9i_template_styles
1 × UPDATE `fly9i_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1714120369;s:18:\"session.timer.last\";i:1714120369;s:17:\"session.timer.now\";i:1714120369;s:24:\"session.client.forwarded\";s:12:\"3.139.238.76\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1714120369'
1 × SHOW FULL COLUMNS
FROM `fly9i_content
1 × UPDATE `fly9i_extensions`
SET `params` = '{\"mediaversion\":\"6dfaa5089689e88db48074794a35a5d3\",\"Array\":[\"28e48f90f35034c8274bcd7e437a465a\"]}'
1 × INSERT INTO `fly9i_session` (`session_id`, `client_id`, `time`)
VALUES ('6aot0g5620okvgm47s2gqnkjs0', 0, '1714120369'
1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM fly9i_acymailing_actio
1 × DELETE
FROM `fly9i_session`