Query Metrics
7
Database Queries
7
Different statements
149.86 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.89 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.28 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 9.25 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 823592 815173 815580 815947 816953 817134 819108 820411 820677 821758 822979 815230 815377 815544 815918 817043 817852 818427 818483 818506 821448 821493 823618 828455 514795 536358 501657 532132 536297 544589 555669 540972 543115 556799 563789 576194 650431 684150 684336 700288 702973 703438 703873 704535 706842 712520 716517 717961 697441 701281 712026 713035 718511 652990 673793 680853 689336 692405 696165 699654 701125 722191 723152 561486 601647 633426 612945 621378 622917 598556 601520 624153 629796 629846 642365 610308 623325 630178 797952 798393 802235 803169 804616 807969 811986 781488 783141 784211 785081 789706 798047 812805 727384 742918 755555 769978 774116 786466 797913 802726 737499 747939 754235 757990 726277 738592 738927 744325 745474 764505 769217 729570 745023 747924 764418 774097 727758 731519 733611 746843 ] |
||||||||||||||||||||||||||||||
| 4 | 3.41 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 501657 514795 532132 536297 536358 540972 543115 544589 555669 556799 561486 563789 576194 598556 601520 601647 610308 612945 621378 622917 623325 624153 629796 629846 630178 633426 642365 650431 652990 673793 680853 684150 684336 689336 692405 696165 697441 699654 700288 701125 701281 702973 703438 703873 704535 706842 712026 712520 713035 716517 717961 718511 722191 723152 726277 727384 727758 729570 731519 733611 737499 738592 738927 742918 744325 745023 745474 746843 747924 747939 754235 755555 757990 764418 764505 769217 769978 774097 774116 781488 783141 784211 785081 786466 789706 797913 797952 798047 798393 802235 802726 803169 804616 807969 811986 812805 815173 815230 815377 815544 815580 815918 816953 817043 817134 817852 818427 818483 818506 819108 820411 820677 821448 821493 821758 822979 823592 823618 828455 ] |
||||||||||||||||||||||||||||||
| 5 | 130.24 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 501657 514795 532132 536297 536358 540972 543115 544589 555669 556799 561486 563789 576194 598556 601520 601647 610308 612945 621378 622917 623325 624153 629796 629846 630178 633426 642365 650431 652990 673793 680853 684150 684336 689336 692405 696165 697441 699654 700288 701125 701281 702973 703438 703873 704535 706842 712026 712520 713035 716517 717961 718511 722191 723152 726277 727384 727758 729570 731519 733611 737499 738592 738927 742918 744325 745023 745474 746843 747924 747939 754235 755555 757990 764418 764505 769217 769978 774097 774116 781488 783141 784211 785081 786466 789706 797913 797952 798047 798393 802235 802726 803169 804616 807969 811986 812805 815173 815230 815377 815544 815580 815918 816953 817043 817134 817852 818427 818483 818506 819108 820411 820677 821448 821493 821758 822979 823592 823618 828455 ] |
||||||||||||||||||||||||||||||
| 6 | 1.56 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.23 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom cock"
]
|
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.