Query Metrics
7
Database Queries
7
Different statements
156.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.05 ms (83.61%) |
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 6670 197443 386065 388907 392597 395781 400843 402425 403663 404019 411734 413429 415928 417942 418066 420606 420865 423364 423815 427093 428207 428668 429288 429355 432458 433686 435104 435198 437242 437459 441877 442158 444671 444916 446281 449702 451254 455562 456876 456887 457577 457881 458649 458738 459022 459308 459552 460264 461272 462258 464068 465116 466452 468878 469629 471774 475693 477695 478163 482579 482619 483334 483997 484992 485062 486133 486167 489226 490652 490709 490712 492161 494834 496375 500249 500314 504206 506106 506754 510424 511066 513647 513936 514011 516715 517497 519452 521076 521793 522049 526137 527022 527588 529451 533632 535918 541245 542964 545622 545636 545651 546770 552181 554804 556614 556808 558578 561636 563398 570273 592486 601425 604857 605674 606016 626978 652907 720464 781147 787172 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (10.53%) |
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 427093 545622 545636 556614 546770 423364 429355 482579 459022 542964 552181 435198 461272 400843 428668 446281 456887 413429 465116 475693 561636 604857 468878 469629 484992 444916 392597 485062 720464 533632 519452 471774 197443 415928 417942 482619 466452 526137 490709 458738 516715 556808 451254 462258 477695 535918 486167 570273 444671 504206 500249 541245 513647 558578 388907 6670 437459 486133 464068 442158 459552 437242 500314 506754 402425 521076 522049 435104 513936 517497 781147 787172 458649 554804 483334 510424 490712 527588 605674 457881 529451 652907 626978 506106 492161 606016 457577 432458 478163 386065 404019 441877 459308 449702 460264 563398 545651 592486 601425 428207 433686 411734 418066 420606 423815 429288 455562 456876 527022 490652 483997 489226 496375 494834 514011 521793 511066 395781 403663 420865 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.85%) |
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 6670 197443 386065 388907 392597 395781 400843 402425 403663 404019 411734 413429 415928 417942 418066 420606 420865 423364 423815 427093 428207 428668 429288 429355 432458 433686 435104 435198 437242 437459 441877 442158 444671 444916 446281 449702 451254 455562 456876 456887 457577 457881 458649 458738 459022 459308 459552 460264 461272 462258 464068 465116 466452 468878 469629 471774 475693 477695 478163 482579 482619 483334 483997 484992 485062 486133 486167 489226 490652 490709 490712 492161 494834 496375 500249 500314 504206 506106 506754 510424 511066 513647 513936 514011 516715 517497 519452 521076 521793 522049 526137 527022 527588 529451 533632 535918 541245 542964 545622 545636 545651 546770 552181 554804 556614 556808 558578 561636 563398 570273 592486 601425 604857 605674 606016 626978 652907 720464 781147 787172 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раком в лифчиком в спа…"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак в бюстгалтер нижн бел в спа"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.81%) |
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.