Query Metrics
7
Database Queries
7
Different statements
169.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.08 ms (82.29%) |
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 390497 391419 397489 398184 402350 409082 413393 415372 427033 441961 445684 452294 452295 457023 457367 457375 457736 458580 458823 458826 458832 459836 466482 477568 477571 477577 477579 482183 482198 494705 505106 522406 522414 540391 542358 542807 542849 543013 543069 543077 543117 543149 543151 543161 543194 543217 543218 543225 543227 543231 543264 543270 543272 543303 543431 543440 543442 543454 543456 543519 543527 543777 543778 543784 543786 543790 543799 544675 547083 550257 552049 556969 557202 565336 565927 567138 568333 569953 574973 577093 585104 586498 586512 586519 586524 591654 596974 598775 600094 608925 614721 618768 622932 627258 628506 629357 636578 637437 640186 652446 667974 671331 671348 671351 681211 688949 732140 733227 757289 759010 789487 789491 794850 803723 805702 813270 813448 813728 813833 813863 ] |
||||||||||||||||||||||||||||||
|
20.01 ms (11.84%) |
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 671331 505106 759010 629357 543272 413393 574973 789487 543790 427033 458823 477577 457375 543077 667974 415372 591654 586512 543777 543227 608925 458832 565336 402350 543431 543786 556969 543264 409082 543784 542807 652446 457367 477571 522406 813448 540391 543225 543013 477579 586519 585104 543149 637437 622932 543303 543270 398184 543194 681211 547083 813833 543231 567138 552049 577093 397489 458826 600094 543218 441961 794850 813270 391419 543440 543519 543161 640186 803723 732140 671351 390497 466482 445684 452295 457736 494705 568333 586498 550257 543454 458580 457023 543117 544675 542358 614721 813863 596974 482198 522414 557202 813728 459836 543151 542849 543799 569953 543778 598775 482183 636578 628506 671348 452294 733227 586524 789491 543217 543527 627258 805702 565927 757289 543069 618768 543456 477568 543442 688949 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.84%) |
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 390497 391419 397489 398184 402350 409082 413393 415372 427033 441961 445684 452294 452295 457023 457367 457375 457736 458580 458823 458826 458832 459836 466482 477568 477571 477577 477579 482183 482198 494705 505106 522406 522414 540391 542358 542807 542849 543013 543069 543077 543117 543149 543151 543161 543194 543217 543218 543225 543227 543231 543264 543270 543272 543303 543431 543440 543442 543454 543456 543519 543527 543777 543778 543784 543786 543790 543799 544675 547083 550257 552049 556969 557202 565336 565927 567138 568333 569953 574973 577093 585104 586498 586512 586519 586524 591654 596974 598775 600094 608925 614721 618768 622932 627258 628506 629357 636578 637437 640186 652446 667974 671331 671348 671351 681211 688949 732140 733227 757289 759010 789487 789491 794850 803723 805702 813270 813448 813728 813833 813863 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"arab blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"араб минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.