Query Metrics
7
Database Queries
7
Different statements
176.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.25 ms (85.81%) |
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 12731 13166 28382 35405 97763 257963 364606 373416 384223 388757 390293 390299 395407 396280 396800 397424 398697 399195 400747 400956 402219 402789 403285 404193 405551 405825 411291 411507 411962 414361 415298 417708 417731 421586 426376 429264 429273 429280 429554 430298 434089 434992 443930 446370 451724 451756 453120 453874 455745 457381 457796 458573 461002 462575 462752 463120 467280 469418 470250 472795 474053 475106 476388 477649 478261 479397 485903 487046 488926 490699 494750 496571 497458 497466 500652 501876 504613 504790 506177 512464 514198 518973 521942 523282 524728 525660 530687 549747 551193 552072 564422 565378 570016 570037 570432 570447 570500 570584 570617 570667 571557 571571 571931 572075 572083 572154 572155 572159 572402 573008 573621 573897 576306 585109 588070 634127 654695 758989 770885 780060 ] |
||||||||||||||||||||||||||||||
|
15.98 ms (9.07%) |
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 530687 476388 402789 403285 457796 770885 35405 458573 405551 451724 457381 758989 417731 390293 429273 588070 512464 398697 426376 479397 518973 490699 429554 12731 396800 373416 654695 506177 364606 400747 415298 453120 570016 477649 434992 501876 28382 443930 570037 504613 524728 397424 576306 451756 395407 525660 572075 404193 411507 585109 399195 551193 390299 402219 405825 469418 497458 496571 463120 467280 552072 573008 429280 421586 411962 430298 461002 488926 494750 549747 571557 573621 570432 573897 780060 257963 429264 487046 523282 497466 485903 462575 475106 500652 570617 571571 572083 472795 455745 388757 514198 97763 411291 446370 400956 521942 434089 453874 570500 570447 572155 564422 571931 572154 634127 462752 396280 470250 384223 414361 13166 417708 478261 504790 474053 565378 572159 570667 572402 570584 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.45%) |
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 12731 13166 28382 35405 97763 257963 364606 373416 384223 388757 390293 390299 395407 396280 396800 397424 398697 399195 400747 400956 402219 402789 403285 404193 405551 405825 411291 411507 411962 414361 415298 417708 417731 421586 426376 429264 429273 429280 429554 430298 434089 434992 443930 446370 451724 451756 453120 453874 455745 457381 457796 458573 461002 462575 462752 463120 467280 469418 470250 472795 474053 475106 476388 477649 478261 479397 485903 487046 488926 490699 494750 496571 497458 497466 500652 501876 504613 504790 506177 512464 514198 518973 521942 523282 524728 525660 530687 549747 551193 552072 564422 565378 570016 570037 570432 570447 570500 570584 570617 570667 571557 571571 571931 572075 572083 572154 572155 572159 572402 573008 573621 573897 576306 585109 588070 634127 654695 758989 770885 780060 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трахаю знакомую"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс знаком"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс знаком"
]
|
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.