Query Metrics
7
Database Queries
7
Different statements
138.93 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.09 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 3.19 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian sex jav"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.86 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 765208 672695 737116 790918 742477 737132 802831 737136 767289 737165 740764 742489 737133 737162 737105 619430 740362 558431 740804 551947 552007 593358 498620 766611 552008 766605 515881 737113 591592 641465 823615 766603 717630 589684 384038 512212 601160 512198 740771 750182 551982 354774 434439 162863 766625 386699 559852 556382 390925 167822 622217 591836 431403 810416 500680 396922 750816 167923 457263 385448 421038 569804 447908 556379 590925 510584 701744 463752 457102 504763 595765 423129 435726 552887 409958 426200 432337 590978 478025 550640 558425 565995 559925 430209 469633 438878 445971 528307 652572 ] |
||||||||||||||||||||||||||||||
| 4 | 2.84 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 162863 167822 167923 354774 384038 385448 386699 390925 396922 409958 421038 423129 426200 430209 431403 432337 434439 435726 438878 445971 447908 457102 457263 463752 469633 478025 498620 500680 504763 510584 512198 512212 515881 528307 550640 551947 551982 552007 552008 552887 556379 556382 558425 558431 559852 559925 565995 569804 589684 590925 590978 591592 591836 593358 595765 601160 619430 622217 641465 652572 672695 701744 717630 737105 737113 737116 737132 737133 737136 737162 737165 740362 740764 740771 740804 742477 742489 750182 750816 765208 766603 766605 766611 766625 767289 790918 802831 810416 823615 ] |
||||||||||||||||||||||||||||||
| 5 | 113.11 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 162863 167822 167923 354774 384038 385448 386699 390925 396922 409958 421038 423129 426200 430209 431403 432337 434439 435726 438878 445971 447908 457102 457263 463752 469633 478025 498620 500680 504763 510584 512198 512212 515881 528307 550640 551947 551982 552007 552008 552887 556379 556382 558425 558431 559852 559925 565995 569804 589684 590925 590978 591592 591836 593358 595765 601160 619430 622217 641465 652572 672695 701744 717630 737105 737113 737116 737132 737133 737136 737162 737165 740362 740764 740771 740804 742477 742489 750182 750816 765208 766603 766605 766611 766625 767289 790918 802831 810416 823615 ] |
||||||||||||||||||||||||||||||
| 6 | 1.89 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк секс jav"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.94 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк секс jav"
]
|
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.