Query Metrics
7
Database Queries
7
Different statements
111.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.63 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.12 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal sex desi"
]
|
||||||||||||||||||||||||||||||
| 3 | 9.89 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 731333 731234 731328 736226 731309 762774 738127 472299 731349 731261 731247 731354 731298 731341 731361 731224 761568 544131 762799 731346 736199 827996 810387 762779 724057 545669 827492 762758 734177 816679 740715 814502 734805 736921 788985 740678 762809 717469 740726 736695 797303 740274 736208 740773 756782 762764 762771 757075 736250 677115 788550 491579 794752 738147 793142 740698 827994 417366 529848 736224 736204 740673 736198 771301 495364 828215 762804 660067 734791 740721 795469 797191 734800 748044 794807 547538 524325 736257 621548 771163 575710 570145 669251 570151 ] |
||||||||||||||||||||||||||||||
| 4 | 2.81 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 417366 472299 491579 495364 524325 529848 544131 545669 547538 570145 570151 575710 621548 660067 669251 677115 717469 724057 731224 731234 731247 731261 731298 731309 731328 731333 731341 731346 731349 731354 731361 734177 734791 734800 734805 736198 736199 736204 736208 736224 736226 736250 736257 736695 736921 738127 738147 740274 740673 740678 740698 740715 740721 740726 740773 748044 756782 761568 762758 762764 762771 762774 762779 762799 762804 762809 771163 771301 788550 788985 793142 794752 794807 795469 797191 797303 810387 814502 816679 827492 827994 827996 828215 ] |
||||||||||||||||||||||||||||||
| 5 | 91.15 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 417366 472299 491579 495364 524325 529848 544131 545669 547538 570145 570151 575710 621548 660067 669251 677115 717469 724057 731224 731234 731247 731261 731298 731309 731328 731333 731341 731346 731349 731354 731361 734177 734791 734800 734805 736198 736199 736204 736208 736224 736226 736250 736257 736695 736921 738127 738147 740274 740673 740678 740698 740715 740721 740726 740773 748044 756782 761568 762758 762764 762771 762774 762779 762799 762804 762809 771163 771301 788550 788985 793142 794752 794807 795469 797191 797303 810387 814502 816679 827492 827994 827996 828215 ] |
||||||||||||||||||||||||||||||
| 6 | 1.70 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал секс desi"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал секс desi"
]
|
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.