Query Metrics
7
Database Queries
7
Different statements
146.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.65 ms (81.06%) |
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 396408 420226 428517 432386 432488 432520 432544 433385 433550 433834 444819 450682 453870 456685 460868 465921 471460 473465 477186 479942 489841 495062 503485 505196 510010 515710 515734 521387 531412 535314 539208 540703 545490 545696 546890 548634 555101 560269 564569 565711 569444 579354 581418 585380 590639 597881 600820 601945 603406 610091 612465 617211 618128 619996 620211 621485 623461 624879 625863 626945 634968 636666 663151 665678 682861 686862 693658 694953 695737 700724 707196 708292 710253 712053 724888 725231 725442 725448 725467 725476 725477 725513 727491 728243 728523 730902 731073 731083 731276 735924 736797 739767 740115 741073 745374 745495 746594 750430 758097 758307 760973 763182 765554 775042 780030 784731 786098 789229 796011 796343 797132 801026 801148 802222 803719 804982 810781 810970 813260 820187 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (11.27%) |
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 803719 725448 745374 746594 786098 796343 739767 728243 731276 735924 741073 789229 444819 465921 396408 432386 433385 473465 515734 505196 618128 432488 428517 820187 450682 460868 479942 521387 539208 555101 707196 663151 665678 682861 695737 546890 590639 634968 600820 612465 636666 620211 810781 775042 802222 725477 725513 727491 797132 813260 725467 763182 725476 745495 758097 758307 603406 624879 433550 477186 432520 432544 433834 515710 510010 420226 471460 489841 453870 456685 495062 503485 540703 531412 535314 560269 579354 581418 545696 564569 569444 708292 693658 694953 700724 686862 710253 712053 545490 548634 565711 585380 621485 625863 619996 610091 597881 617211 626945 796011 801148 804982 780030 801026 810970 725231 725442 731083 740115 784731 730902 728523 736797 760973 731073 765554 724888 750430 601945 623461 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.34%) |
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 396408 420226 428517 432386 432488 432520 432544 433385 433550 433834 444819 450682 453870 456685 460868 465921 471460 473465 477186 479942 489841 495062 503485 505196 510010 515710 515734 521387 531412 535314 539208 540703 545490 545696 546890 548634 555101 560269 564569 565711 569444 579354 581418 585380 590639 597881 600820 601945 603406 610091 612465 617211 618128 619996 620211 621485 623461 624879 625863 626945 634968 636666 663151 665678 682861 686862 693658 694953 695737 700724 707196 708292 710253 712053 724888 725231 725442 725448 725467 725476 725477 725513 727491 728243 728523 730902 731073 731083 731276 735924 736797 739767 740115 741073 745374 745495 746594 750430 758097 758307 760973 763182 765554 775042 780030 784731 786098 789229 796011 796343 797132 801026 801148 802222 803719 804982 810781 810970 813260 820187 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum pantyhose"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum pantyhose"
]
|
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.