Query Metrics
7
Database Queries
7
Different statements
575.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
549.54 ms (95.52%) |
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 150405 384144 412043 414350 428238 429801 445367 453406 458764 461890 468120 473429 476082 476783 482712 485149 488475 497517 501643 527780 532790 532852 532855 533870 536628 545046 547467 548517 549137 549996 551319 551442 552664 552791 553274 555104 557376 559161 560164 560216 560459 561140 562844 564387 564706 565039 566553 567097 567321 567337 568457 568478 569258 569457 569550 569556 569722 569736 569770 570390 570854 570857 571216 573743 574196 579685 582024 583041 585960 586561 590218 590246 590952 591109 591383 592444 593270 593743 593877 594956 596242 598113 599664 599921 600027 600273 600626 603210 603674 603723 603927 604766 604800 605470 607080 607565 617416 625888 631457 651128 660023 660399 660410 670495 714475 726081 727580 727622 728060 729281 752878 773554 773895 776503 782018 784961 785431 800005 803610 807170 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (2.84%) |
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 800005 428238 533870 567321 660399 603210 592444 468120 532855 384144 603674 776503 773554 536628 414350 532790 547467 660410 553274 569258 599921 585960 593743 617416 461890 560459 566553 570857 569770 570854 557376 600027 600273 590952 586561 591383 596242 773895 150405 453406 568478 573743 569736 651128 670495 570390 631457 607565 600626 604800 807170 729281 727580 728060 752878 473429 497517 555104 476783 785431 488475 560164 660023 545046 551319 604766 726081 803610 458764 501643 532852 568457 567337 583041 782018 784961 429801 445367 527780 476082 714475 605470 485149 603723 412043 564387 564706 571216 569457 591109 593877 552791 560216 569556 551442 599664 482712 549137 598113 603927 625888 548517 565039 569550 569722 574196 579685 549996 562844 567097 590246 593270 607080 594956 590218 727622 559161 552664 561140 582024 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (0.49%) |
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 150405 384144 412043 414350 428238 429801 445367 453406 458764 461890 468120 473429 476082 476783 482712 485149 488475 497517 501643 527780 532790 532852 532855 533870 536628 545046 547467 548517 549137 549996 551319 551442 552664 552791 553274 555104 557376 559161 560164 560216 560459 561140 562844 564387 564706 565039 566553 567097 567321 567337 568457 568478 569258 569457 569550 569556 569722 569736 569770 570390 570854 570857 571216 573743 574196 579685 582024 583041 585960 586561 590218 590246 590952 591109 591383 592444 593270 593743 593877 594956 596242 598113 599664 599921 600027 600273 600626 603210 603674 603723 603927 604766 604800 605470 607080 607565 617416 625888 631457 651128 660023 660399 660410 670495 714475 726081 727580 727622 728060 729281 752878 773554 773895 776503 782018 784961 785431 800005 803610 807170 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big butt mother"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие butt мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие butt мам женщин"
]
|
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.