Query Metrics
7
Database Queries
7
Different statements
187.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.71 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.94 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom beauty"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.63 ms |
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 431691 432837 442783 450803 451086 479019 401226 409258 428472 445424 464404 465834 414946 449760 509503 507834 516966 520021 523762 529170 484768 489971 512895 516886 517278 523323 529305 492096 513116 515031 516209 522168 525469 477335 388012 818467 818869 817091 819054 819247 815537 819249 825004 817043 818427 823618 496713 514795 537698 537874 495384 531052 531666 535487 537722 538918 501657 529895 534686 535790 537539 537562 547323 547331 549960 550007 568241 569746 574180 543934 579912 541160 547297 550384 556799 567981 646865 684150 687127 700288 714384 713035 718511 689336 699654 722191 547885 561559 561771 571184 597209 601647 633426 639683 598390 593165 598274 601520 626563 629846 630281 618377 775341 797952 802567 806837 811315 787634 804770 813486 769978 787362 747939 726210 755183 729570 747924 751485 752185 774078 ] |
||||||||||||||||||||||||||||||
| 4 | 3.40 ms |
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 388012 401226 409258 414946 428472 431691 432837 442783 445424 449760 450803 451086 464404 465834 477335 479019 484768 489971 492096 495384 496713 501657 507834 509503 512895 513116 514795 515031 516209 516886 516966 517278 520021 522168 523323 523762 525469 529170 529305 529895 531052 531666 534686 535487 535790 537539 537562 537698 537722 537874 538918 541160 543934 547297 547323 547331 547885 549960 550007 550384 556799 561559 561771 567981 568241 569746 571184 574180 579912 593165 597209 598274 598390 601520 601647 618377 626563 629846 630281 633426 639683 646865 684150 687127 689336 699654 700288 713035 714384 718511 722191 726210 729570 747924 747939 751485 752185 755183 769978 774078 775341 787362 787634 797952 802567 804770 806837 811315 813486 815537 817043 817091 818427 818467 818869 819054 819247 819249 823618 825004 ] |
||||||||||||||||||||||||||||||
| 5 | 165.14 ms |
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 388012 401226 409258 414946 428472 431691 432837 442783 445424 449760 450803 451086 464404 465834 477335 479019 484768 489971 492096 495384 496713 501657 507834 509503 512895 513116 514795 515031 516209 516886 516966 517278 520021 522168 523323 523762 525469 529170 529305 529895 531052 531666 534686 535487 535790 537539 537562 537698 537722 537874 538918 541160 543934 547297 547323 547331 547885 549960 550007 550384 556799 561559 561771 567981 568241 569746 571184 574180 579912 593165 597209 598274 598390 601520 601647 618377 626563 629846 630281 633426 639683 646865 684150 687127 689336 699654 700288 713035 714384 718511 722191 726210 729570 747924 747939 751485 752185 755183 769978 774078 775341 787362 787634 797952 802567 804770 806837 811315 813486 815537 817043 817091 818427 818467 818869 819054 819247 819249 823618 825004 ] |
||||||||||||||||||||||||||||||
| 6 | 1.77 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom beauty"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.49 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom beauty"
]
|
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.