Query Metrics
7
Database Queries
7
Different statements
168.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.51 ms (84.69%) |
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 371202 411319 411552 416300 417945 422132 425299 425302 425323 425485 426057 426496 427490 428872 433701 434530 434531 434655 435232 435723 436830 436850 437451 437786 437790 439175 442844 444326 444712 445655 446182 449342 449344 450119 450160 450547 451958 451961 452046 452133 452162 452399 452732 455393 456055 456378 456566 456797 459607 460119 460324 461678 467068 473118 480334 489260 492835 494168 494461 495255 496405 502508 504171 507674 511213 520125 525107 526706 527697 528267 530209 539894 551248 556063 557809 558778 561806 563390 569579 570038 571875 572165 574415 579861 582566 592373 593095 593795 600888 602475 608317 613286 614170 616816 629868 631632 663098 686168 712549 716014 719851 729678 731110 739648 746876 762638 762743 764250 765102 774343 779534 779768 786119 786542 795632 796009 808260 810699 810970 810974 ] |
||||||||||||||||||||||||||||||
|
15.90 ms (9.45%) |
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 762638 608317 450160 558778 436830 433701 434531 452133 467068 663098 461678 764250 435232 411319 422132 435723 556063 444712 459607 455393 525107 574415 629868 808260 739648 810970 810699 712549 810974 450547 686168 582566 446182 600888 442844 779768 492835 460324 452046 456378 437790 460119 416300 434655 426496 571875 572165 436850 426057 716014 563390 795632 779534 452162 427490 444326 449344 456797 502508 425485 425323 417945 425302 411552 456055 494461 570038 746876 511213 786542 527697 520125 450119 456566 449342 494168 551248 569579 593795 593095 425299 439175 473118 452732 480334 428872 437451 445655 528267 496405 507674 602475 613286 631632 561806 614170 786119 762743 452399 530209 719851 729678 371202 557809 796009 731110 765102 774343 526706 592373 539894 489260 579861 616816 434530 437786 504171 451958 451961 495255 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.48%) |
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 371202 411319 411552 416300 417945 422132 425299 425302 425323 425485 426057 426496 427490 428872 433701 434530 434531 434655 435232 435723 436830 436850 437451 437786 437790 439175 442844 444326 444712 445655 446182 449342 449344 450119 450160 450547 451958 451961 452046 452133 452162 452399 452732 455393 456055 456378 456566 456797 459607 460119 460324 461678 467068 473118 480334 489260 492835 494168 494461 495255 496405 502508 504171 507674 511213 520125 525107 526706 527697 528267 530209 539894 551248 556063 557809 558778 561806 563390 569579 570038 571875 572165 574415 579861 582566 592373 593095 593795 600888 602475 608317 613286 614170 616816 629868 631632 663098 686168 712549 716014 719851 729678 731110 739648 746876 762638 762743 764250 765102 774343 779534 779768 786119 786542 795632 796009 808260 810699 810970 810974 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oral blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"oral минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"oral минет оральн секс"
]
|
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.