Query Metrics
7
Database Queries
7
Different statements
157.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.21 ms (82.05%) |
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 358410 383501 384581 384865 386475 395550 422024 423426 423767 424742 428155 434550 439271 440977 443744 444608 444836 445256 448937 454535 457776 458383 460608 463839 467103 467143 467188 475826 477133 483654 484792 486171 486702 489648 501295 502295 506664 507008 515779 516509 521160 523465 542302 544438 552809 555592 555593 558077 560138 560903 563084 564267 576139 577849 580576 584913 587477 591558 594874 598781 604151 611603 614937 618361 620121 623193 628347 630222 640891 656197 659164 673138 673142 682502 685852 689315 689358 689693 689736 697298 698293 698972 700851 703193 712959 715323 715410 718223 719703 721907 726055 730947 734189 737465 739187 741076 744368 744381 761553 761603 761633 766687 766767 775239 777168 780060 782123 782179 782187 792664 794301 796178 796354 798881 798908 805037 805122 806715 814613 819395 ] |
||||||||||||||||||||||||||||||
|
17.73 ms (11.26%) |
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 819395 796178 715410 712959 782187 744381 467103 698293 486171 805122 423426 424742 457776 428155 659164 591558 805037 734189 682502 395550 673138 386475 604151 798908 507008 640891 782123 766767 515779 618361 739187 454535 718223 440977 477133 689315 555592 555593 502295 501295 623193 766687 484792 458383 521160 560903 598781 719703 761633 741076 780060 628347 444608 506664 775239 792664 689736 384865 798881 697298 656197 796354 577849 552809 673142 726055 384581 358410 587477 698972 782179 761603 737465 730947 383501 445256 761553 777168 443744 448937 560138 620121 486702 814613 580576 423767 523465 439271 689693 715323 700851 703193 806715 434550 467188 611603 467143 544438 614937 558077 584913 460608 422024 576139 744368 483654 685852 794301 542302 475826 516509 721907 463839 594874 630222 444836 489648 689358 563084 564267 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.92%) |
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 358410 383501 384581 384865 386475 395550 422024 423426 423767 424742 428155 434550 439271 440977 443744 444608 444836 445256 448937 454535 457776 458383 460608 463839 467103 467143 467188 475826 477133 483654 484792 486171 486702 489648 501295 502295 506664 507008 515779 516509 521160 523465 542302 544438 552809 555592 555593 558077 560138 560903 563084 564267 576139 577849 580576 584913 587477 591558 594874 598781 604151 611603 614937 618361 620121 623193 628347 630222 640891 656197 659164 673138 673142 682502 685852 689315 689358 689693 689736 697298 698293 698972 700851 703193 712959 715323 715410 718223 719703 721907 726055 730947 734189 737465 739187 741076 744368 744381 761553 761603 761633 766687 766767 775239 777168 780060 782123 782179 782187 792664 794301 796178 796354 798881 798908 805037 805122 806715 814613 819395 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden anal fuck"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
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.