Query Metrics
7
Database Queries
7
Different statements
182.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.10 ms (83.21%) |
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 382818 390790 398119 402969 411552 417068 420824 422427 422495 423155 424247 425287 427129 427985 434470 434531 438006 443443 450118 451506 455244 455463 455628 455781 456055 456512 456589 457093 460109 461732 461809 462555 462571 463347 463807 475571 477188 479361 480278 481198 485142 489715 490710 493024 493286 498723 505359 505360 506649 516215 517316 522124 525599 537240 542509 544275 546806 553242 556504 560243 561809 561912 563555 564125 565086 565328 568681 578221 582121 584825 586188 588060 588173 588508 590577 594079 595111 601945 615650 626074 626489 628480 647140 666404 674340 679166 680572 692074 692653 704341 709635 712869 720530 722040 731521 732744 739627 758512 761436 761789 763079 766882 771734 779037 779262 781479 783385 786990 787130 789588 789843 790256 791109 793593 794106 794668 796011 805000 805141 805152 ] |
||||||||||||||||||||||||||||||
|
18.00 ms (9.85%) |
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 758512 450118 489715 588508 463807 709635 582121 761436 779262 783385 398119 402969 456589 457093 771734 789588 455244 561809 786990 462571 556504 590577 595111 790256 794106 781479 794668 763079 731521 704341 789843 479361 626074 692653 422427 455463 434531 456512 382818 390790 588173 791109 578221 568681 553242 588060 626489 805000 761789 805152 739627 427129 417068 434470 420824 505359 560243 525599 542509 647140 425287 517316 720530 732744 793593 584825 485142 480278 544275 565328 722040 680572 712869 586188 615650 628480 796011 805141 787130 601945 451506 461809 481198 493286 455628 477188 411552 456055 475571 462555 490710 564125 422495 443443 461732 424247 438006 455781 522124 493024 498723 506649 423155 766882 516215 460109 565086 674340 692074 779037 594079 463347 427985 505360 537240 546806 561912 563555 679166 666404 ] |
||||||||||||||||||||||||||||||
|
4.56 ms (2.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
2.33 ms (1.28%) |
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 382818 390790 398119 402969 411552 417068 420824 422427 422495 423155 424247 425287 427129 427985 434470 434531 438006 443443 450118 451506 455244 455463 455628 455781 456055 456512 456589 457093 460109 461732 461809 462555 462571 463347 463807 475571 477188 479361 480278 481198 485142 489715 490710 493024 493286 498723 505359 505360 506649 516215 517316 522124 525599 537240 542509 544275 546806 553242 556504 560243 561809 561912 563555 564125 565086 565328 568681 578221 582121 584825 586188 588060 588173 588508 590577 594079 595111 601945 615650 626074 626489 628480 647140 666404 674340 679166 680572 692074 692653 704341 709635 712869 720530 722040 731521 732744 739627 758512 761436 761789 763079 766882 771734 779037 779262 781479 783385 786990 787130 789588 789843 790256 791109 793593 794106 794668 796011 805000 805141 805152 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob with cum"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.