Query Metrics
7
Database Queries
7
Different statements
148.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.26 ms (83.55%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 91560 187789 357595 381853 382272 383209 384282 398497 406063 406068 407637 407705 407773 409408 411572 411742 411756 443676 443965 453121 453136 454186 460254 462080 462099 462130 464960 466257 466903 466961 467239 467536 470762 472151 474496 474497 474878 475044 475220 476334 479766 480764 485740 485754 485758 487343 487347 487358 496347 498019 506817 507128 515911 516475 519135 519142 519152 520094 524880 533889 534245 537832 545005 545895 545924 548052 549982 554326 558293 558296 558299 558300 559059 563424 565661 567412 567422 567427 567435 568325 573912 583144 591481 598949 599277 621750 623477 624478 624865 629572 661948 663935 665357 666093 666153 666741 667669 677969 716470 724290 726580 728316 729100 729797 730452 744232 762245 770201 781447 781961 784632 789250 789693 800702 801822 806311 807997 814113 824603 825241 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (10.19%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 480764 661948 599277 398497 800702 519142 443676 567422 466903 485758 474497 383209 474496 781961 462099 567435 443965 466961 558293 666153 789250 545895 623477 406068 407773 485740 357595 407705 515911 667669 591481 516475 598949 467536 520094 548052 824603 573912 807997 726580 475220 583144 472151 479766 475044 533889 524880 453136 474878 454186 384282 716470 770201 487358 558299 549982 729797 485754 567427 558296 730452 565661 781447 568325 762245 462080 187789 411572 624478 545924 453121 462130 382272 784632 407637 381853 519152 663935 487343 724290 801822 814113 729100 498019 507128 411742 744232 91560 825241 460254 406063 629572 554326 464960 409408 470762 558300 537832 666741 665357 666093 411756 506817 496347 519135 467239 567412 624865 621750 728316 806311 466257 476334 559059 789693 534245 677969 487347 545005 563424 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.57%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 91560 187789 357595 381853 382272 383209 384282 398497 406063 406068 407637 407705 407773 409408 411572 411742 411756 443676 443965 453121 453136 454186 460254 462080 462099 462130 464960 466257 466903 466961 467239 467536 470762 472151 474496 474497 474878 475044 475220 476334 479766 480764 485740 485754 485758 487343 487347 487358 496347 498019 506817 507128 515911 516475 519135 519142 519152 520094 524880 533889 534245 537832 545005 545895 545924 548052 549982 554326 558293 558296 558299 558300 559059 563424 565661 567412 567422 567427 567435 568325 573912 583144 591481 598949 599277 621750 623477 624478 624865 629572 661948 663935 665357 666093 666153 666741 667669 677969 716470 724290 726580 728316 729100 729797 730452 744232 762245 770201 781447 781961 784632 789250 789693 800702 801822 806311 807997 814113 824603 825241 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"granny maid sex"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"granny горничн секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"granny горничн секс"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.