Query: SELECT COUNT(user_id) AS total FROM phpbb_users WHERE user_id <> -1 Time before: 0.0690848827362 Time after: 0.0725607872009 Elapsed time: 0.00347590446472
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_users | index | PRIMARY | PRIMARY | 3 | 3374 | 1 | Using where; Using index |
Query: SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total FROM phpbb_forums Time before: 0.0730218887329 Time after: 0.0733768939972 Elapsed time: 0.000355005264282
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_forums | ALL | 28 | 1 |
Query: SELECT user_id, username FROM phpbb_users WHERE user_id <> -1 ORDER BY user_id DESC LIMIT 1 Time before: 0.073716878891 Time after: 0.0741319656372 Elapsed time: 0.000415086746216
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_users | index | PRIMARY | PRIMARY | 3 | 3374 | 1 | Using where |
Query: SELECT user_regdate FROM phpbb_users WHERE user_id = 7475 LIMIT 1 Time before: 0.152506828308 Time after: 0.153226852417 Elapsed time: 0.000720024108887
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_users | const | PRIMARY | PRIMARY | 3 | const | 1 | 1 |
Query: SELECT * FROM phpbb_config WHERE config_name = 'record_online_users' OR config_name = 'record_online_date' Time before: 0.153777837753 Time after: 0.153891801834 Elapsed time: 0.000113964080811
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_config | range | PRIMARY | PRIMARY | 257 | 2 | 2 | Using where |
Query: SELECT topic_id, forum_id, topic_title, topic_replies FROM phpbb_topics WHERE (topic_status <> 2) AND (topic_replies > 0) ORDER BY topic_replies DESC LIMIT 10 Time before: 0.205446004868 Time after: 0.22690486908 Elapsed time: 0.021458864212
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_topics | ALL | 16377 | 10 | Using where; Using filesort |
Query: SELECT forum_id, topic_id, topic_title, topic_views FROM phpbb_topics WHERE (topic_status <> 2) AND (topic_views > 0) ORDER BY topic_views DESC LIMIT 10 Time before: 0.25267291069 Time after: 0.275743961334 Elapsed time: 0.0230710506439
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_topics | ALL | 16377 | 10 | Using where; Using filesort |
Query: SELECT SUM(user_posts) as total_posts FROM phpbb_users WHERE user_id <> -1 Time before: 0.285758018494 Time after: 0.377419948578 Elapsed time: 0.0916619300842
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_users | ALL | PRIMARY | 3374 | 1 | Using where |
Query: SELECT user_id, username, user_posts FROM phpbb_users WHERE (user_id <> -1 ) AND (user_posts > 0) ORDER BY user_posts DESC LIMIT 10 Time before: 0.377990961075 Time after: 0.470234870911 Elapsed time: 0.0922439098358
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_users | ALL | PRIMARY | 3374 | 10 | Using where; Using filesort |
Query: SELECT * FROM stats_smilies_info Time before: 0.480865001678 Time after: 0.493360996246 Elapsed time: 0.0124959945679
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | stats_smilies_info | system | 1 | 1 |
Query: SELECT * FROM stats_smilies_index Time before: 0.493922948837 Time after: 0.494114875793 Elapsed time: 0.000191926956177
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | stats_smilies_index | ALL | 86 | 86 |
Query: SELECT max(post_id) as total FROM phpbb_posts Time before: 0.495445013046 Time after: 0.495687961578 Elapsed time: 0.000242948532104
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | 1 | Select tables optimized away |
Query: SELECT COUNT(post_id) as total FROM phpbb_posts Time before: 0.496039867401 Time after: 0.496214866638 Elapsed time: 0.000174999237061
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | 1 | Select tables optimized away |
Query: SELECT smile_url FROM phpbb_smilies GROUP BY smile_url Time before: 0.496508836746 Time after: 0.496647834778 Elapsed time: 0.000138998031616
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 86 | Using temporary; Using filesort |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'akkordeon.gif' Time before: 0.49751496315 Time after: 0.497630834579 Elapsed time: 0.000115871429443
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:BB-)%' AND post_id > 237834 Time before: 0.498025894165 Time after: 0.498648881912 Elapsed time: 0.000622987747192
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'angel.gif' Time before: 0.499106884003 Time after: 0.499228954315 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%(-)%' AND post_id > 237834 Time before: 0.49959897995 Time after: 0.500160932541 Elapsed time: 0.000561952590942
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'applaus.gif' Time before: 0.500597000122 Time after: 0.500723838806 Elapsed time: 0.000126838684082
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%!!-!!%' AND post_id > 237834 Time before: 0.501093864441 Time after: 0.501644849777 Elapsed time: 0.000550985336304
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'ballos.gif' Time before: 0.502082824707 Time after: 0.502201795578 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%oooo-%' AND post_id > 237834 Time before: 0.502564907074 Time after: 0.503151893616 Elapsed time: 0.000586986541748
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'biggun2.gif' Time before: 0.503582000732 Time after: 0.503704786301 Elapsed time: 0.000122785568237
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%---((( ;-)%' AND post_id > 237834 Time before: 0.504073858261 Time after: 0.504607915878 Elapsed time: 0.000534057617188
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'bigwave.gif' Time before: 0.505066871643 Time after: 0.505191802979 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-)) @%' AND post_id > 237834 Time before: 0.50556397438 Time after: 0.506133794785 Elapsed time: 0.000569820404053
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'Boom.gif' Time before: 0.50656580925 Time after: 0.506682872772 Elapsed time: 0.000117063522339
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%---(( ---%' AND post_id > 237834 Time before: 0.507082939148 Time after: 0.50762796402 Elapsed time: 0.000545024871826
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'cake.gif' Time before: 0.508069992065 Time after: 0.508191823959 Elapsed time: 0.000121831893921
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%iiic%' AND post_id > 237834 Time before: 0.508557796478 Time after: 0.509155988693 Elapsed time: 0.000598192214966
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'cross_arms.gif' Time before: 0.509593009949 Time after: 0.509718894958 Elapsed time: 0.000125885009766
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 2 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:[-(%' AND post_id > 237834 Time before: 0.510098934174 Time after: 0.510663986206 Elapsed time: 0.000565052032471
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%CC-(%' AND post_id > 237834 Time before: 0.511083841324 Time after: 0.511638879776 Elapsed time: 0.000555038452148
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'Cup off coffee.gif' Time before: 0.512069940567 Time after: 0.512188911438 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 2 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:~0)%' AND post_id > 237834 Time before: 0.512564897537 Time after: 0.51314496994 Elapsed time: 0.000580072402954
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Th-)%' AND post_id > 237834 Time before: 0.513559818268 Time after: 0.514137983322 Elapsed time: 0.000578165054321
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'dance.gif' Time before: 0.514566898346 Time after: 0.514688014984 Elapsed time: 0.000121116638184
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%00--))%' AND post_id > 237834 Time before: 0.515065908432 Time after: 0.515613794327 Elapsed time: 0.000547885894775
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'drink.gif' Time before: 0.516057014465 Time after: 0.516178846359 Elapsed time: 0.000121831893921
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%!;-)(-:!%' AND post_id > 237834 Time before: 0.516548871994 Time after: 0.517100811005 Elapsed time: 0.00055193901062
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'drinken.gif' Time before: 0.517535924911 Time after: 0.517651796341 Elapsed time: 0.000115871429443
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%hh-)%' AND post_id > 237834 Time before: 0.518028020859 Time after: 0.518593788147 Elapsed time: 0.000565767288208
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'finger.gif' Time before: 0.519068956375 Time after: 0.519189834595 Elapsed time: 0.000120878219604
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:(!)%' AND post_id > 237834 Time before: 0.519567012787 Time after: 0.520162820816 Elapsed time: 0.000595808029175
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'firstprize.gif' Time before: 0.520602941513 Time after: 0.520727872849 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-) -}}%' AND post_id > 237834 Time before: 0.521098852158 Time after: 0.521638870239 Elapsed time: 0.000540018081665
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'flame.gif' Time before: 0.522080898285 Time after: 0.522202014923 Elapsed time: 0.000121116638184
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:;-) ------%' AND post_id > 237834 Time before: 0.522565841675 Time after: 0.523106813431 Elapsed time: 0.000540971755981
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'friet-1.gif' Time before: 0.523538827896 Time after: 0.523656845093 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-)<<%' AND post_id > 237834 Time before: 0.524087905884 Time after: 0.52464389801 Elapsed time: 0.000555992126465
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'gayfight.gif' Time before: 0.525099992752 Time after: 0.525218009949 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:((-))%' AND post_id > 237834 Time before: 0.525585889816 Time after: 0.526142835617 Elapsed time: 0.000556945800781
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'gayno.gif' Time before: 0.526578903198 Time after: 0.526704788208 Elapsed time: 0.000125885009766
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-))----)%' AND post_id > 237834 Time before: 0.527076005936 Time after: 0.527596950531 Elapsed time: 0.000520944595337
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'haha.gif' Time before: 0.528039932251 Time after: 0.528162002563 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-0%' AND post_id > 237834 Time before: 0.528528928757 Time after: 0.529068946838 Elapsed time: 0.000540018081665
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'happybirth.gif' Time before: 0.529500007629 Time after: 0.529620885849 Elapsed time: 0.000120878219604
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%happy-)%' AND post_id > 237834 Time before: 0.529996871948 Time after: 0.530524015427 Elapsed time: 0.000527143478394
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'help3.gif' Time before: 0.530961990356 Time after: 0.531086921692 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%HELP-(%' AND post_id > 237834 Time before: 0.531447887421 Time after: 0.532001972198 Elapsed time: 0.000554084777832
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_arrow.gif' Time before: 0.532435894012 Time after: 0.532552957535 Elapsed time: 0.000117063522339
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:arrow:%' AND post_id > 237834 Time before: 0.532925844193 Time after: 0.5334649086 Elapsed time: 0.000539064407349
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_biggrin.gif' Time before: 0.533905982971 Time after: 0.534029006958 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-D%' AND post_id > 237834 Time before: 0.5343978405 Time after: 0.534952878952 Elapsed time: 0.000555038452148
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 1 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_confused.gif' Time before: 0.535390853882 Time after: 0.535508871078 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-?%' AND post_id > 237834 Time before: 0.535879850388 Time after: 0.536417007446 Elapsed time: 0.000537157058716
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_cool.gif' Time before: 0.536861896515 Time after: 0.536992788315 Elapsed time: 0.000130891799927
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:8-)%' AND post_id > 237834 Time before: 0.537370920181 Time after: 0.537954807281 Elapsed time: 0.00058388710022
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_cry.gif' Time before: 0.538400888443 Time after: 0.538517951965 Elapsed time: 0.000117063522339
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:cry:%' AND post_id > 237834 Time before: 0.538889884949 Time after: 0.539470911026 Elapsed time: 0.000581026077271
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_eek.gif' Time before: 0.539923906326 Time after: 0.540045022964 Elapsed time: 0.000121116638184
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:shock:%' AND post_id > 237834 Time before: 0.540412902832 Time after: 0.540964841843 Elapsed time: 0.00055193901062
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 1 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_evil.gif' Time before: 0.541468858719 Time after: 0.541591882706 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:evil:%' AND post_id > 237834 Time before: 0.541990995407 Time after: 0.542550802231 Elapsed time: 0.00055980682373
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_exclaim.gif' Time before: 0.543010950089 Time after: 0.543137788773 Elapsed time: 0.000126838684082
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:!:%' AND post_id > 237834 Time before: 0.543509960175 Time after: 0.544065952301 Elapsed time: 0.000555992126465
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 1 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_idea.gif' Time before: 0.544503927231 Time after: 0.544620990753 Elapsed time: 0.000117063522339
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:idea:%' AND post_id > 237834 Time before: 0.545003890991 Time after: 0.545559883118 Elapsed time: 0.000555992126465
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_lol.gif' Time before: 0.546008825302 Time after: 0.546127796173 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:lol:%' AND post_id > 237834 Time before: 0.546494960785 Time after: 0.547080993652 Elapsed time: 0.000586032867432
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 3 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_mad.gif' Time before: 0.547521829605 Time after: 0.547639846802 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%-x%' AND post_id > 237834 Time before: 0.548020839691 Time after: 0.548551797867 Elapsed time: 0.000530958175659
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_mrgreen.gif' Time before: 0.549004793167 Time after: 0.549122810364 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:mrgreen:%' AND post_id > 237834 Time before: 0.549489021301 Time after: 0.550029993057 Elapsed time: 0.000540971755981
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_neutral.gif' Time before: 0.55046582222 Time after: 0.550587892532 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-|%' AND post_id > 237834 Time before: 0.550964832306 Time after: 0.551512002945 Elapsed time: 0.000547170639038
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_question.gif' Time before: 0.551949977875 Time after: 0.552073001862 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:?:%' AND post_id > 237834 Time before: 0.55243897438 Time after: 0.552981853485 Elapsed time: 0.000542879104614
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_razz.gif' Time before: 0.553417921066 Time after: 0.553536891937 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-P%' AND post_id > 237834 Time before: 0.553950786591 Time after: 0.554493904114 Elapsed time: 0.000543117523193
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_redface.gif' Time before: 0.554936885834 Time after: 0.555060863495 Elapsed time: 0.000123977661133
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:oops:%' AND post_id > 237834 Time before: 0.555428981781 Time after: 0.555996894836 Elapsed time: 0.00056791305542
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 1 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_rolleyes.gif' Time before: 0.556438922882 Time after: 0.556559801102 Elapsed time: 0.000120878219604
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:roll:%' AND post_id > 237834 Time before: 0.556932926178 Time after: 0.557478904724 Elapsed time: 0.000545978546143
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_sad.gif' Time before: 0.557919979095 Time after: 0.558039903641 Elapsed time: 0.000119924545288
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-(%' AND post_id > 237834 Time before: 0.55840587616 Time after: 0.558945894241 Elapsed time: 0.000540018081665
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_smile.gif' Time before: 0.559391975403 Time after: 0.559510946274 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-)%' AND post_id > 237834 Time before: 0.559883832932 Time after: 0.560429811478 Elapsed time: 0.000545978546143
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 1 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_surprised.gif' Time before: 0.560875892639 Time after: 0.561000823975 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:-o%' AND post_id > 237834 Time before: 0.561366796494 Time after: 0.561908006668 Elapsed time: 0.000541210174561
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_twisted.gif' Time before: 0.562353849411 Time after: 0.562474966049 Elapsed time: 0.000121116638184
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:twisted:%' AND post_id > 237834 Time before: 0.562844991684 Time after: 0.563388824463 Elapsed time: 0.000543832778931
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'icon_wink.gif' Time before: 0.56383895874 Time after: 0.563961982727 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-)%' AND post_id > 237834 Time before: 0.564337968826 Time after: 0.564913988113 Elapsed time: 0.000576019287109
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 3 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'ignore.gif' Time before: 0.565366983414 Time after: 0.565485954285 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%-XX%' AND post_id > 237834 Time before: 0.56586098671 Time after: 0.566393852234 Elapsed time: 0.000532865524292
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'jerry.gif' Time before: 0.56684088707 Time after: 0.566962957382 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:--()%' AND post_id > 237834 Time before: 0.56733584404 Time after: 0.567892789841 Elapsed time: 0.000556945800781
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'jump.gif' Time before: 0.568336963654 Time after: 0.568456888199 Elapsed time: 0.000119924545288
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-)(-)%' AND post_id > 237834 Time before: 0.568838834763 Time after: 0.569397926331 Elapsed time: 0.000559091567993
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'jumpie.gif' Time before: 0.569859981537 Time after: 0.569993019104 Elapsed time: 0.000133037567139
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:00000%' AND post_id > 237834 Time before: 0.570371866226 Time after: 0.570918798447 Elapsed time: 0.000546932220459
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'kiss.gif' Time before: 0.571370840073 Time after: 0.571488857269 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-0-9%' AND post_id > 237834 Time before: 0.57186293602 Time after: 0.572410821915 Elapsed time: 0.000547885894775
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'laola.gif' Time before: 0.572860956192 Time after: 0.572988986969 Elapsed time: 0.000128030776978
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%WA-)%' AND post_id > 237834 Time before: 0.573356866837 Time after: 0.57392001152 Elapsed time: 0.000563144683838
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'lekkerpuh.gif' Time before: 0.574368953705 Time after: 0.574491024017 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:*-)*%' AND post_id > 237834 Time before: 0.574867963791 Time after: 0.57541680336 Elapsed time: 0.000548839569092
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'minifeier002.gif' Time before: 0.575862884521 Time after: 0.575990915298 Elapsed time: 0.000128030776978
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Trrr-)%' AND post_id > 237834 Time before: 0.576358795166 Time after: 0.576906919479 Elapsed time: 0.000548124313354
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'minifeier004.gif' Time before: 0.57735490799 Time after: 0.577475786209 Elapsed time: 0.000120878219604
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%pakje-)%' AND post_id > 237834 Time before: 0.577847957611 Time after: 0.578382968903 Elapsed time: 0.000535011291504
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'offtopic.gif' Time before: 0.578846931458 Time after: 0.578975915909 Elapsed time: 0.000128984451294
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:OFF%' AND post_id > 237834 Time before: 0.579351902008 Time after: 0.57995390892 Elapsed time: 0.000602006912231
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'oud.gif' Time before: 0.58041882515 Time after: 0.580541849136 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%:oud%' AND post_id > 237834 Time before: 0.58091878891 Time after: 0.581503868103 Elapsed time: 0.000585079193115
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'paars.gif' Time before: 0.581955909729 Time after: 0.582080841064 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%cry-(%' AND post_id > 237834 Time before: 0.582453012466 Time after: 0.583021879196 Elapsed time: 0.000568866729736
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'party.gif' Time before: 0.583469867706 Time after: 0.583590984344 Elapsed time: 0.000121116638184
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%00-)%' AND post_id > 237834 Time before: 0.583966016769 Time after: 0.584528923035 Elapsed time: 0.000562906265259
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'proost.gif' Time before: 0.584980010986 Time after: 0.585097789764 Elapsed time: 0.000117778778076
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%II-)%' AND post_id > 237834 Time before: 0.585464954376 Time after: 0.586030006409 Elapsed time: 0.000565052032471
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'rain.gif' Time before: 0.586473941803 Time after: 0.586593866348 Elapsed time: 0.000119924545288
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%,,,,.....-(%' AND post_id > 237834 Time before: 0.586973905563 Time after: 0.587504863739 Elapsed time: 0.000530958175659
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'rocketwhore.gif' Time before: 0.58798289299 Time after: 0.588107824326 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%rocket%' AND post_id > 237834 Time before: 0.588481903076 Time after: 0.589058876038 Elapsed time: 0.000576972961426
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'sad.gif' Time before: 0.589504957199 Time after: 0.58962392807 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%O-((%' AND post_id > 237834 Time before: 0.590006828308 Time after: 0.590569019318 Elapsed time: 0.000562191009521
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'schater.gif' Time before: 0.591045856476 Time after: 0.59116601944 Elapsed time: 0.000120162963867
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%schater%' AND post_id > 237834 Time before: 0.591535806656 Time after: 0.592105865479 Elapsed time: 0.000570058822632
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'schla03.gif' Time before: 0.592558860779 Time after: 0.592686891556 Elapsed time: 0.000128030776978
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Zz-)%' AND post_id > 237834 Time before: 0.593076944351 Time after: 0.593641996384 Elapsed time: 0.000565052032471
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'schla11.gif' Time before: 0.594105958939 Time after: 0.594227790833 Elapsed time: 0.000121831893921
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Zzz-)%' AND post_id > 237834 Time before: 0.594595909119 Time after: 0.595161914825 Elapsed time: 0.000566005706787
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'schla24.gif' Time before: 0.595604896545 Time after: 0.59586596489 Elapsed time: 0.000261068344116
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Zzz-)%' AND post_id > 237834 Time before: 0.596280813217 Time after: 0.596391916275 Elapsed time: 0.000111103057861
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'sheildsmile.gif' Time before: 0.596862792969 Time after: 0.596995830536 Elapsed time: 0.000133037567139
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%sheilds%' AND post_id > 237834 Time before: 0.597380876541 Time after: 0.597945928574 Elapsed time: 0.000565052032471
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'shhh.gif' Time before: 0.598395824432 Time after: 0.598517894745 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 2 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%;-$%' AND post_id > 237834 Time before: 0.59890294075 Time after: 0.59944486618 Elapsed time: 0.000541925430298
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Shhhhhh-)%' AND post_id > 237834 Time before: 0.599858999252 Time after: 0.600381851196 Elapsed time: 0.00052285194397
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'slotje.gif' Time before: 0.600828886032 Time after: 0.600947856903 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%slotje%' AND post_id > 237834 Time before: 0.601347923279 Time after: 0.601921796799 Elapsed time: 0.000573873519897
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie-027.gif' Time before: 0.602381944656 Time after: 0.602504014969 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%jha-)%' AND post_id > 237834 Time before: 0.602893829346 Time after: 0.603460788727 Elapsed time: 0.000566959381104
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie-angry01.gif' Time before: 0.603920936584 Time after: 0.604044914246 Elapsed time: 0.000123977661133
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%ang-(%' AND post_id > 237834 Time before: 0.604427814484 Time after: 0.604997873306 Elapsed time: 0.000570058822632
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie-angry02.gif' Time before: 0.605460882187 Time after: 0.605579853058 Elapsed time: 0.000118970870972
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%ang-2-(%' AND post_id > 237834 Time before: 0.605975866318 Time after: 0.606514930725 Elapsed time: 0.000539064407349
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie-kus.gif' Time before: 0.607039928436 Time after: 0.607163906097 Elapsed time: 0.000123977661133
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%kis-)%' AND post_id > 237834 Time before: 0.607555866241 Time after: 0.608197927475 Elapsed time: 0.000642061233521
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie_antasie1.gif' Time before: 0.608799934387 Time after: 0.608925819397 Elapsed time: 0.000125885009766
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%antasie-)%' AND post_id > 237834 Time before: 0.609329938889 Time after: 0.609879970551 Elapsed time: 0.000550031661987
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie_bierglas.gif' Time before: 0.61035490036 Time after: 0.610476016998 Elapsed time: 0.000121116638184
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%beer-)%' AND post_id > 237834 Time before: 0.610873937607 Time after: 0.611431837082 Elapsed time: 0.000557899475098
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie_foryou.gif' Time before: 0.611897945404 Time after: 0.61202287674 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%mail-)%' AND post_id > 237834 Time before: 0.61240696907 Time after: 0.61296081543 Elapsed time: 0.000553846359253
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie_koch1.gif' Time before: 0.61342382431 Time after: 0.613546848297 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%kok-)%' AND post_id > 237834 Time before: 0.613938808441 Time after: 0.614493846893 Elapsed time: 0.000555038452148
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie_n01.gif' Time before: 0.614956855774 Time after: 0.615081787109 Elapsed time: 0.000124931335449
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%NL-)%' AND post_id > 237834 Time before: 0.615467786789 Time after: 0.616041898727 Elapsed time: 0.000574111938477
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'smilie_saft3.gif' Time before: 0.616503953934 Time after: 0.616626977921 Elapsed time: 0.000123023986816
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%saft-(%' AND post_id > 237834 Time before: 0.617020845413 Time after: 0.617565870285 Elapsed time: 0.000545024871826
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'Smoker.gif' Time before: 0.618036985397 Time after: 0.618156909943 Elapsed time: 0.000119924545288
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%smoker%' AND post_id > 237834 Time before: 0.618548870087 Time after: 0.61913895607 Elapsed time: 0.000590085983276
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'sport11.gif' Time before: 0.619594812393 Time after: 0.619724988937 Elapsed time: 0.000130176544189
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%sp-)%' AND post_id > 237834 Time before: 0.62012887001 Time after: 0.620703935623 Elapsed time: 0.000575065612793
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'sport23.gif' Time before: 0.621183872223 Time after: 0.621315002441 Elapsed time: 0.000131130218506
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%Ughh-)%' AND post_id > 237834 Time before: 0.621719837189 Time after: 0.622277021408 Elapsed time: 0.00055718421936
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'sport25.gif' Time before: 0.622751951218 Time after: 0.622871875763 Elapsed time: 0.000119924545288
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%BBB-)%' AND post_id > 237834 Time before: 0.623261928558 Time after: 0.623828887939 Elapsed time: 0.000566959381104
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'trink3.gif' Time before: 0.62429189682 Time after: 0.624413967133 Elapsed time: 0.0001220703125
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%klu-)%' AND post_id > 237834 Time before: 0.624804973602 Time after: 0.625360965729 Elapsed time: 0.000555992126465
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'trink6.gif' Time before: 0.625839948654 Time after: 0.625965833664 Elapsed time: 0.000125885009766
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%proost-)%' AND post_id > 237834 Time before: 0.626355886459 Time after: 0.626904010773 Elapsed time: 0.000548124313354
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'welcome.gif' Time before: 0.627372980118 Time after: 0.627490997314 Elapsed time: 0.000118017196655
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%welc-)%' AND post_id > 237834 Time before: 0.627885818481 Time after: 0.628448963165 Elapsed time: 0.000563144683838
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: SELECT * FROM phpbb_smilies WHERE smile_url = 'whaa.gif' Time before: 0.62891793251 Time after: 0.629041910172 Elapsed time: 0.000123977661133
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_smilies | ALL | 89 | 1 | Using where |
Query: SELECT post_id, post_text FROM phpbb_posts_text WHERE post_text LIKE '%whaa-(%' AND post_id > 237834 Time before: 0.629432916641 Time after: 0.630075931549 Elapsed time: 0.000643014907837
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | affected_rows | Extra |
| 1 | SIMPLE | phpbb_posts_text | range | PRIMARY | PRIMARY | 3 | 40 | 0 | Using where |
Query: UPDATE stats_smilies_index SET smile_count = 60 WHERE smile_url = 'akkordeon.gif' Time before: 0.630539894104 Time after: 0.641774892807 Elapsed time: 0.011234998703
Query: UPDATE stats_smilies_index SET smile_count = 97 WHERE smile_url = 'angel.gif' Time before: 0.641879796982 Time after: 0.642465829849 Elapsed time: 0.000586032867432
Query: UPDATE stats_smilies_index SET smile_count = 124 WHERE smile_url = 'applaus.gif' Time before: 0.642548799515 Time after: 0.643126010895 Elapsed time: 0.000577211380005
Query: UPDATE stats_smilies_index SET smile_count = 127 WHERE smile_url = 'ballos.gif' Time before: 0.643206834793 Time after: 0.643780946732 Elapsed time: 0.000574111938477
Query: UPDATE stats_smilies_index SET smile_count = 31 WHERE smile_url = 'biggun2.gif' Time before: 0.643862009048 Time after: 0.644428014755 Elapsed time: 0.000566005706787
Query: UPDATE stats_smilies_index SET smile_count = 22 WHERE smile_url = 'bigwave.gif' Time before: 0.644507884979 Time after: 0.645081996918 Elapsed time: 0.000574111938477
Query: UPDATE stats_smilies_index SET smile_count = 38 WHERE smile_url = 'Boom.gif' Time before: 0.645162820816 Time after: 0.645731925964 Elapsed time: 0.000569105148315
Query: UPDATE stats_smilies_index SET smile_count = 109 WHERE smile_url = 'cake.gif' Time before: 0.64580988884 Time after: 0.646377801895 Elapsed time: 0.00056791305542
Query: UPDATE stats_smilies_index SET smile_count = 21 WHERE smile_url = 'cross_arms.gif' Time before: 0.646456956863 Time after: 0.647030830383 Elapsed time: 0.000573873519897
Query: UPDATE stats_smilies_index SET smile_count = 9 WHERE smile_url = 'Cup off coffee.gif' Time before: 0.647110939026 Time after: 0.647684812546 Elapsed time: 0.000573873519897
Query: UPDATE stats_smilies_index SET smile_count = 124 WHERE smile_url = 'dance.gif' Time before: 0.647773981094 Time after: 0.648367881775 Elapsed time: 0.000593900680542
Query: UPDATE stats_smilies_index SET smile_count = 39 WHERE smile_url = 'drink.gif' Time before: 0.648448944092 Time after: 0.649029970169 Elapsed time: 0.000581026077271
Query: UPDATE stats_smilies_index SET smile_count = 303 WHERE smile_url = 'drinken.gif' Time before: 0.649109840393 Time after: 0.649679899216 Elapsed time: 0.000570058822632
Query: UPDATE stats_smilies_index SET smile_count = 15 WHERE smile_url = 'finger.gif' Time before: 0.649758815765 Time after: 0.650329828262 Elapsed time: 0.000571012496948
Query: UPDATE stats_smilies_index SET smile_count = 44 WHERE smile_url = 'firstprize.gif' Time before: 0.650408983231 Time after: 0.650981903076 Elapsed time: 0.000572919845581
Query: UPDATE stats_smilies_index SET smile_count = 10 WHERE smile_url = 'flame.gif' Time before: 0.651060819626 Time after: 0.65162396431 Elapsed time: 0.000563144683838
Query: UPDATE stats_smilies_index SET smile_count = 14 WHERE smile_url = 'friet-1.gif' Time before: 0.651708841324 Time after: 0.652279853821 Elapsed time: 0.000571012496948
Query: UPDATE stats_smilies_index SET smile_count = 15 WHERE smile_url = 'gayfight.gif' Time before: 0.652359962463 Time after: 0.65293097496 Elapsed time: 0.000571012496948
Query: UPDATE stats_smilies_index SET smile_count = 5 WHERE smile_url = 'gayno.gif' Time before: 0.653021812439 Time after: 0.653587818146 Elapsed time: 0.000566005706787
Query: UPDATE stats_smilies_index SET smile_count = 53 WHERE smile_url = 'haha.gif' Time before: 0.653673887253 Time after: 0.654246807098 Elapsed time: 0.000572919845581
Query: UPDATE stats_smilies_index SET smile_count = 196 WHERE smile_url = 'happybirth.gif' Time before: 0.654326915741 Time after: 0.654896974564 Elapsed time: 0.000570058822632
Query: UPDATE stats_smilies_index SET smile_count = 54 WHERE smile_url = 'help3.gif' Time before: 0.654978990555 Time after: 0.655540943146 Elapsed time: 0.000561952590942
Query: UPDATE stats_smilies_index SET smile_count = 206 WHERE smile_url = 'icon_arrow.gif' Time before: 0.655619859695 Time after: 0.656194925308 Elapsed time: 0.000575065612793
Query: UPDATE stats_smilies_index SET smile_count = 3704 WHERE smile_url = 'icon_biggrin.gif' Time before: 0.656274795532 Time after: 0.657233953476 Elapsed time: 0.000959157943726
Query: UPDATE stats_smilies_index SET smile_count = 1241 WHERE smile_url = 'icon_confused.gif' Time before: 0.657342910767 Time after: 0.657963991165 Elapsed time: 0.00062108039856
Query: UPDATE stats_smilies_index SET smile_count = 1731 WHERE smile_url = 'icon_cool.gif' Time before: 0.658048868179 Time after: 0.658614873886 Elapsed time: 0.000566005706787
Query: UPDATE stats_smilies_index SET smile_count = 2846 WHERE smile_url = 'icon_cry.gif' Time before: 0.658701896667 Time after: 0.659279823303 Elapsed time: 0.000577926635742
Query: UPDATE stats_smilies_index SET smile_count = 3291 WHERE smile_url = 'icon_eek.gif' Time before: 0.659359931946 Time after: 0.659965991974 Elapsed time: 0.000606060028076
Query: UPDATE stats_smilies_index SET smile_count = 1674 WHERE smile_url = 'icon_evil.gif' Time before: 0.660049915314 Time after: 0.660623788834 Elapsed time: 0.000573873519897
Query: UPDATE stats_smilies_index SET smile_count = 4426 WHERE smile_url = 'icon_exclaim.gif' Time before: 0.660710811615 Time after: 0.661314964294 Elapsed time: 0.000604152679443
Query: UPDATE stats_smilies_index SET smile_count = 867 WHERE smile_url = 'icon_idea.gif' Time before: 0.66139793396 Time after: 0.661980867386 Elapsed time: 0.000582933425903
Query: UPDATE stats_smilies_index SET smile_count = 17197 WHERE smile_url = 'icon_lol.gif' Time before: 0.662062883377 Time after: 0.662657022476 Elapsed time: 0.000594139099121
Query: UPDATE stats_smilies_index SET smile_count = 249 WHERE smile_url = 'icon_mad.gif' Time before: 0.662738800049 Time after: 0.663313865662 Elapsed time: 0.000575065612793
Query: UPDATE stats_smilies_index SET smile_count = 581 WHERE smile_url = 'icon_mrgreen.gif' Time before: 0.663393974304 Time after: 0.663965940475 Elapsed time: 0.000571966171265
Query: UPDATE stats_smilies_index SET smile_count = 48 WHERE smile_url = 'icon_neutral.gif' Time before: 0.664047956467 Time after: 0.664613962173 Elapsed time: 0.000566005706787
Query: UPDATE stats_smilies_index SET smile_count = 4552 WHERE smile_url = 'icon_question.gif' Time before: 0.664698839188 Time after: 0.665271997452 Elapsed time: 0.00057315826416
Query: UPDATE stats_smilies_index SET smile_count = 1091 WHERE smile_url = 'icon_razz.gif' Time before: 0.66535282135 Time after: 0.665925979614 Elapsed time: 0.00057315826416
Query: UPDATE stats_smilies_index SET smile_count = 3655 WHERE smile_url = 'icon_redface.gif' Time before: 0.666009902954 Time after: 0.666598796844 Elapsed time: 0.000588893890381
Query: UPDATE stats_smilies_index SET smile_count = 3465 WHERE smile_url = 'icon_rolleyes.gif' Time before: 0.666707992554 Time after: 0.667307853699 Elapsed time: 0.00059986114502
Query: UPDATE stats_smilies_index SET smile_count = 787 WHERE smile_url = 'icon_sad.gif' Time before: 0.667392969131 Time after: 0.667976856232 Elapsed time: 0.00058388710022
Query: UPDATE stats_smilies_index SET smile_count = 1950 WHERE smile_url = 'icon_smile.gif' Time before: 0.668058872223 Time after: 0.668668985367 Elapsed time: 0.000610113143921
Query: UPDATE stats_smilies_index SET smile_count = 106 WHERE smile_url = 'icon_surprised.gif' Time before: 0.668758869171 Time after: 0.66934800148 Elapsed time: 0.00058913230896
Query: UPDATE stats_smilies_index SET smile_count = 3469 WHERE smile_url = 'icon_twisted.gif' Time before: 0.66943192482 Time after: 0.670008897781 Elapsed time: 0.000576972961426
Query: UPDATE stats_smilies_index SET smile_count = 15454 WHERE smile_url = 'icon_wink.gif' Time before: 0.670090913773 Time after: 0.670694828033 Elapsed time: 0.000603914260864
Query: UPDATE stats_smilies_index SET smile_count = 28 WHERE smile_url = 'ignore.gif' Time before: 0.670777797699 Time after: 0.671350955963 Elapsed time: 0.00057315826416
Query: UPDATE stats_smilies_index SET smile_count = 3 WHERE smile_url = 'jerry.gif' Time before: 0.671429872513 Time after: 0.672001838684 Elapsed time: 0.000571966171265
Query: UPDATE stats_smilies_index SET smile_count = 66 WHERE smile_url = 'jump.gif' Time before: 0.672081947327 Time after: 0.672649860382 Elapsed time: 0.00056791305542
Query: UPDATE stats_smilies_index SET smile_count = 13 WHERE smile_url = 'jumpie.gif' Time before: 0.67272901535 Time after: 0.673296928406 Elapsed time: 0.00056791305542
Query: UPDATE stats_smilies_index SET smile_count = 15 WHERE smile_url = 'kiss.gif' Time before: 0.673374891281 Time after: 0.673946857452 Elapsed time: 0.000571966171265
Query: UPDATE stats_smilies_index SET smile_count = 829 WHERE smile_url = 'laola.gif' Time before: 0.674026966095 Time after: 0.674592018127 Elapsed time: 0.000565052032471
Query: UPDATE stats_smilies_index SET smile_count = 41 WHERE smile_url = 'lekkerpuh.gif' Time before: 0.6746737957 Time after: 0.675241947174 Elapsed time: 0.000568151473999
Query: UPDATE stats_smilies_index SET smile_count = 96 WHERE smile_url = 'minifeier002.gif' Time before: 0.675321817398 Time after: 0.676024913788 Elapsed time: 0.000703096389771
Query: UPDATE stats_smilies_index SET smile_count = 102 WHERE smile_url = 'minifeier004.gif' Time before: 0.676117897034 Time after: 0.676714897156 Elapsed time: 0.00059700012207
Query: UPDATE stats_smilies_index SET smile_count = 17 WHERE smile_url = 'offtopic.gif' Time before: 0.676796913147 Time after: 0.677367925644 Elapsed time: 0.000571012496948
Query: UPDATE stats_smilies_index SET smile_count = 35 WHERE smile_url = 'oud.gif' Time before: 0.677447795868 Time after: 0.678021907806 Elapsed time: 0.000574111938477
Query: UPDATE stats_smilies_index SET smile_count = 45 WHERE smile_url = 'paars.gif' Time before: 0.678102016449 Time after: 0.678671836853 Elapsed time: 0.000569820404053
Query: UPDATE stats_smilies_index SET smile_count = 243 WHERE smile_url = 'party.gif' Time before: 0.678750991821 Time after: 0.679308891296 Elapsed time: 0.000557899475098
Query: UPDATE stats_smilies_index SET smile_count = 261 WHERE smile_url = 'proost.gif' Time before: 0.679389953613 Time after: 0.679956912994 Elapsed time: 0.000566959381104
Query: UPDATE stats_smilies_index SET smile_count = 35 WHERE smile_url = 'rain.gif' Time before: 0.680037975311 Time after: 0.680594921112 Elapsed time: 0.000556945800781
Query: UPDATE stats_smilies_index SET smile_count = 28 WHERE smile_url = 'rocketwhore.gif' Time before: 0.680678844452 Time after: 0.681241989136 Elapsed time: 0.000563144683838
Query: UPDATE stats_smilies_index SET smile_count = 26 WHERE smile_url = 'sad.gif' Time before: 0.681322813034 Time after: 0.681887865067 Elapsed time: 0.000565052032471
Query: UPDATE stats_smilies_index SET smile_count = 79 WHERE smile_url = 'schater.gif' Time before: 0.681972980499 Time after: 0.6825299263 Elapsed time: 0.000556945800781
Query: UPDATE stats_smilies_index SET smile_count = 135 WHERE smile_url = 'schla03.gif' Time before: 0.682609796524 Time after: 0.683178901672 Elapsed time: 0.000569105148315
Query: UPDATE stats_smilies_index SET smile_count = 65 WHERE smile_url = 'schla11.gif' Time before: 0.683259010315 Time after: 0.683825016022 Elapsed time: 0.000566005706787
Query: UPDATE stats_smilies_index SET smile_count = 65 WHERE smile_url = 'schla24.gif' Time before: 0.683904886246 Time after: 0.684466838837 Elapsed time: 0.000561952590942
Query: UPDATE stats_smilies_index SET smile_count = 4 WHERE smile_url = 'sheildsmile.gif' Time before: 0.684547901154 Time after: 0.685122966766 Elapsed time: 0.000575065612793
Query: UPDATE stats_smilies_index SET smile_count = 109 WHERE smile_url = 'shhh.gif' Time before: 0.685204982758 Time after: 0.685771942139 Elapsed time: 0.000566959381104
Query: UPDATE stats_smilies_index SET smile_count = 164 WHERE smile_url = 'slotje.gif' Time before: 0.685850858688 Time after: 0.686412811279 Elapsed time: 0.000561952590942
Query: UPDATE stats_smilies_index SET smile_count = 53 WHERE smile_url = 'smilie-027.gif' Time before: 0.686492919922 Time after: 0.687060832977 Elapsed time: 0.00056791305542
Query: UPDATE stats_smilies_index SET smile_count = 16 WHERE smile_url = 'smilie-angry01.gif' Time before: 0.687141895294 Time after: 0.687711000443 Elapsed time: 0.000569105148315
Query: UPDATE stats_smilies_index SET smile_count = 25 WHERE smile_url = 'smilie-angry02.gif' Time before: 0.687791824341 Time after: 0.68835401535 Elapsed time: 0.000562191009521
Query: UPDATE stats_smilies_index SET smile_count = 63 WHERE smile_url = 'smilie-kus.gif' Time before: 0.688433885574 Time after: 0.689002990723 Elapsed time: 0.000569105148315
Query: UPDATE stats_smilies_index SET smile_count = 16 WHERE smile_url = 'smilie_antasie1.gif' Time before: 0.689082860947 Time after: 0.68964600563 Elapsed time: 0.000563144683838
Query: UPDATE stats_smilies_index SET smile_count = 422 WHERE smile_url = 'smilie_bierglas.gif' Time before: 0.689728021622 Time after: 0.690292835236 Elapsed time: 0.000564813613892
Query: UPDATE stats_smilies_index SET smile_count = 9 WHERE smile_url = 'smilie_foryou.gif' Time before: 0.690383911133 Time after: 0.690948963165 Elapsed time: 0.000565052032471
Query: UPDATE stats_smilies_index SET smile_count = 36 WHERE smile_url = 'smilie_koch1.gif' Time before: 0.691040992737 Time after: 0.691591978073 Elapsed time: 0.000550985336304
Query: UPDATE stats_smilies_index SET smile_count = 30 WHERE smile_url = 'smilie_n01.gif' Time before: 0.691684961319 Time after: 0.692228794098 Elapsed time: 0.000543832778931
Query: UPDATE stats_smilies_index SET smile_count = 13 WHERE smile_url = 'smilie_saft3.gif' Time before: 0.69235086441 Time after: 0.692899942398 Elapsed time: 0.000549077987671
Query: UPDATE stats_smilies_index SET smile_count = 8 WHERE smile_url = 'Smoker.gif' Time before: 0.692989826202 Time after: 0.693527936935 Elapsed time: 0.000538110733032
Query: UPDATE stats_smilies_index SET smile_count = 43 WHERE smile_url = 'sport11.gif' Time before: 0.693614006042 Time after: 0.694163799286 Elapsed time: 0.000549793243408
Query: UPDATE stats_smilies_index SET smile_count = 41 WHERE smile_url = 'sport23.gif' Time before: 0.694249868393 Time after: 0.694795846939 Elapsed time: 0.000545978546143
Query: UPDATE stats_smilies_index SET smile_count = 32 WHERE smile_url = 'sport25.gif' Time before: 0.694881916046 Time after: 0.695434808731 Elapsed time: 0.000552892684937
Query: UPDATE stats_smilies_index SET smile_count = 146 WHERE smile_url = 'trink3.gif' Time before: 0.695519924164 Time after: 0.696071863174 Elapsed time: 0.00055193901062
Query: UPDATE stats_smilies_index SET smile_count = 192 WHERE smile_url = 'trink6.gif' Time before: 0.696156978607 Time after: 0.696702957153 Elapsed time: 0.000545978546143
Query: UPDATE stats_smilies_index SET smile_count = 245 WHERE smile_url = 'welcome.gif' Time before: 0.696788787842 Time after: 0.697331905365 Elapsed time: 0.000543117523193
Query: UPDATE stats_smilies_index SET smile_count = 107 WHERE smile_url = 'whaa.gif' Time before: 0.697417974472 Time after: 0.697962999344 Elapsed time: 0.000545024871826
Query: UPDATE stats_smilies_info SET last_post_id = 237863 Time before: 0.698045969009 Time after: 0.698421001434 Elapsed time: 0.000375032424927
The Statistics Mod generated 276 queries, spending 0.367453575134 doing MySQL queries and 0.351909399033 doing PHP things.