Query Metrics
7
Database Queries
7
Different statements
144.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.32 ms (81.44%) |
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 432227 437845 444329 448041 448282 455095 455100 455105 455108 461516 461520 461526 461535 461545 461549 461552 461566 462045 462052 462805 467844 472334 472347 472350 472353 473685 476213 478923 487069 487080 487086 487088 487089 487114 491199 491659 491671 500926 508804 508827 508876 508881 510618 511709 511720 511730 511750 512239 512244 512280 512297 512323 512335 512900 517574 522590 524697 524708 524724 524732 527623 527807 544337 552116 552142 558858 558946 560464 560476 560629 562209 562320 565449 567633 573453 573773 573775 574509 574600 574810 574829 574843 574871 574885 575120 575148 575453 575520 575758 575805 576026 576053 576351 606690 606694 654617 654619 654717 654771 654783 655358 656048 656361 656465 656686 656708 656751 657074 657287 657420 657434 658014 658656 659161 659642 659669 659842 669344 696178 705118 ] |
||||||||||||||||||||||||||||||
|
17.60 ms (12.21%) |
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 476213 455108 472353 508876 491199 544337 657420 657434 654717 659642 669344 654619 656361 656751 658014 437845 657074 658656 659161 656048 567633 573453 467844 511750 491659 508804 512244 576053 448282 478923 472350 511709 511720 512280 552142 560476 565449 573773 574885 575805 576026 573775 574509 575453 552116 560464 562209 574600 574810 574871 575520 575758 696178 558858 558946 560629 562320 574843 575148 576351 606690 606694 705118 455095 462052 473685 472334 455100 461520 461526 461535 461549 461552 461566 462805 432227 444329 448041 455105 462045 472347 461516 461545 512323 522590 527623 487086 500926 511730 512335 517574 487069 508881 510618 512297 487080 487089 487114 491671 508827 512239 524697 524708 524724 524732 527807 656708 657287 654617 659842 655358 656465 656686 659669 487088 512900 574829 575120 654771 654783 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.65%) |
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 432227 437845 444329 448041 448282 455095 455100 455105 455108 461516 461520 461526 461535 461545 461549 461552 461566 462045 462052 462805 467844 472334 472347 472350 472353 473685 476213 478923 487069 487080 487086 487088 487089 487114 491199 491659 491671 500926 508804 508827 508876 508881 510618 511709 511720 511730 511750 512239 512244 512280 512297 512323 512335 512900 517574 522590 524697 524708 524724 524732 527623 527807 544337 552116 552142 558858 558946 560464 560476 560629 562209 562320 565449 567633 573453 573773 573775 574509 574600 574810 574829 574843 574871 574885 575120 575148 575453 575520 575758 575805 576026 576053 576351 606690 606694 654617 654619 654717 654771 654783 655358 656048 656361 656465 656686 656708 656751 657074 657287 657420 657434 658014 658656 659161 659642 659669 659842 669344 696178 705118 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куколд 18 летние"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд 18 19 лет"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд 18 19 лет"
]
|
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.