Query Metrics
7
Database Queries
7
Different statements
196.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.07 ms (88.22%) |
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 395317 395398 395401 398830 417005 417878 428810 437302 437338 444044 446204 461727 489102 492931 506127 515623 516476 517280 527154 539654 543995 547834 550703 551128 551908 559173 560319 561447 562453 568566 569394 570825 578057 578705 579571 579838 589711 590223 594583 595734 602475 604243 610672 621322 626135 626561 638688 641462 641464 643324 646395 649212 670634 680852 680853 683682 691832 695151 697221 701221 710259 713329 714795 715768 717665 718388 718448 718456 718786 722678 724227 726265 735750 735917 736905 742665 750724 751508 751600 757642 758089 759866 760695 767996 769456 771251 771490 773267 775379 776737 776840 777217 777228 778784 779565 785662 785824 787686 788274 789314 790830 793368 795409 796492 798535 799983 801786 803756 805141 805145 809529 813475 817247 817912 818135 823406 824810 825797 825798 ] |
||||||||||||||||||||||||||||||
|
13.82 ms (7.05%) |
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 790830 489102 697221 777217 437338 506127 492931 446204 461727 516476 444044 559173 551128 562453 543995 680853 813475 742665 825797 680852 757642 735917 724227 785662 428810 818135 626135 796492 789314 760695 569394 777228 759866 751508 822897 823406 517280 539654 722678 683682 809529 817912 527154 551908 649212 718448 718786 626561 641462 805145 776737 788274 773267 726265 735750 771490 714795 718456 785824 799983 398830 395317 817247 579838 701221 646395 776840 778784 779565 801786 824810 560319 695151 590223 604243 621322 795409 787686 750724 767996 758089 769456 798535 395398 825798 515623 710259 715768 718388 670634 570825 594583 641464 638688 775379 793368 805141 751600 736905 771251 610672 713329 417878 417005 437302 395401 561447 579571 568566 717665 691832 547834 550703 578057 578705 643324 589711 595734 602475 803756 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.58%) |
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 395317 395398 395401 398830 417005 417878 428810 437302 437338 444044 446204 461727 489102 492931 506127 515623 516476 517280 527154 539654 543995 547834 550703 551128 551908 559173 560319 561447 562453 568566 569394 570825 578057 578705 579571 579838 589711 590223 594583 595734 602475 604243 610672 621322 626135 626561 638688 641462 641464 643324 646395 649212 670634 680852 680853 683682 691832 695151 697221 701221 710259 713329 714795 715768 717665 718388 718448 718456 718786 722678 724227 726265 735750 735917 736905 742665 750724 751508 751600 757642 758089 759866 760695 767996 769456 771251 771490 773267 775379 776737 776840 777217 777228 778784 779565 785662 785824 787686 788274 789314 790830 793368 795409 796492 798535 799983 801786 803756 805141 805145 809529 813475 817247 817912 818135 823406 824810 825797 825798 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom on hotel"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom hotel"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom hotel"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.