Code:
Array
(
[0] => Array
(
[0] => SELECT * FROM tl_session WHERE hash='fcb2afd349719542783c45ed63b50100a4356f65' AND name='BE_USER_AUTH'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_session
[type] => system
[possible_keys] => hash
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[1] => Array
(
[0] => SELECT * FROM tl_user WHERE id='1'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_user
[type] => const
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] => const
[rows] => 1
[Extra] =>
)
)
[2] => Array
(
[0] => SELECT * FROM tl_user_group WHERE id=NULL AND disable!=1 AND (start='' OR start<1278926345) AND (stop='' OR stop>1278926345) LIMIT 0,1
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] =>
[type] =>
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] =>
[Extra] => Impossible WHERE noticed after reading const tables
)
)
[3] => Array
(
[0] => UPDATE tl_session SET tstamp=1278926345 WHERE sessionID='d28886f9b0bcc7f16ef54f561050b0c5'
[1] => 1 rows affected
)
[4] => Array
(
[0] => SELECT * FROM tl_catalog_fields WHERE pid='2' ORDER BY sorting
[1] => 46 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_fields
[type] => ALL
[possible_keys] => pid
[key] =>
[key_len] =>
[ref] =>
[rows] => 35
[Extra] => Using where; Using filesort
)
)
[5] => Array
(
[0] => SHOW COLUMNS FROM `tl_taxonomy`
[1] => 7 rows affected
)
[6] => Array
(
[0] => SELECT id, name FROM tl_taxonomy WHERE id IN (63,64,65,66,67) ORDER BY name
[1] => 5 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 5
[Extra] => Using where; Using filesort
)
)
[7] => Array
(
[0] => SELECT id, name FROM tl_taxonomy WHERE id IN (6,7,8,9,10,11,12,13,14) ORDER BY name
[1] => 9 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 65
[Extra] => Using where; Using filesort
)
)
[8] => Array
(
[0] => SELECT id, name FROM tl_taxonomy WHERE id IN (77,78,79,80,81,82,83,84,85,86) ORDER BY name
[1] => 10 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 65
[Extra] => Using where; Using filesort
)
)
[9] => Array
(
[0] => SELECT id, name FROM tl_taxonomy WHERE id IN (74,75) ORDER BY name
[1] => 2 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => range
[possible_keys] => PRIMARY
[key] => PRIMARY
[key_len] => 4
[ref] =>
[rows] => 2
[Extra] => Using where; Using filesort
)
)
[10] => Array
(
[0] => SELECT id, name FROM tl_taxonomy WHERE id IN (87,88,72,68,69,70,71,19,20,21,22,23,24,25,26,27,59) ORDER BY alias
[1] => 17 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_taxonomy
[type] => ALL
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 65
[Extra] => Using where; Using filesort
)
)
[11] => Array
(
[0] => UPDATE tl_catalog_types SET dca='REMOVED BECAUSE OF SECURITY' WHERE id='2'
[1] => 0 rows affected
)
[12] => Array
(
[0] => DELETE FROM tl_catalog_fields WHERE id IN(1,2,3,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,49,50,51,52,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,100,101,104,105,106,107,108) AND tstamp=0
[1] => 0 rows affected
)
[13] => Array
(
[0] => DELETE FROM tl_catalog_fields WHERE NOT EXISTS (SELECT * FROM tl_catalog_types WHERE tl_catalog_fields.pid = tl_catalog_types.id)
[1] => 0 rows affected
)
[14] => Array
(
[0] => SHOW COLUMNS FROM `tl_catalog_fields`
[1] => 43 rows affected
)
[15] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_catalog_fields WHERE pid='2'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_fields
[type] => ref
[possible_keys] => pid
[key] => pid
[key_len] => 4
[ref] => const
[rows] => 45
[Extra] => Using index
)
)
[16] => Array
(
[0] => SELECT * FROM tl_catalog_types WHERE id='2' LIMIT 0,1
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_types
[type] => system
[possible_keys] => PRIMARY
[key] =>
[key_len] =>
[ref] =>
[rows] => 1
[Extra] =>
)
)
[17] => Array
(
[0] => SELECT MAX(tstamp) AS tstamp FROM tl_catalog_fields WHERE pid='2'
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_catalog_fields
[type] => ALL
[possible_keys] => pid
[key] =>
[key_len] =>
[ref] =>
[rows] => 35
[Extra] => Using where
)
)
)
I only have edited the UPDATE statement, because there were sensible data in it.
Ghost entries
Reply With Quote
Originally Posted by thyon
ok, i have read all the topic and found the solution, thanks
Bookmarks