Query Metrics
7
Database Queries
7
Different statements
190.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.35 ms (84.91%) |
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 188062 391437 417174 420178 427241 428238 435695 439518 440893 441354 444745 448806 448832 450250 452797 453824 454270 457902 458924 460726 462305 462317 463073 464326 465337 466195 466561 466814 469396 469508 470071 472147 472595 473453 474674 474844 474848 475895 476195 476262 482552 484762 486345 486355 487054 487360 487750 491403 493127 493163 493206 495154 497492 497520 498623 499851 499906 502275 502278 502283 502868 507284 508807 509964 511856 512947 518238 518554 518918 519947 522863 523562 523565 524947 524949 525133 525490 528474 534553 537117 555582 558261 559324 574298 576695 581937 589573 590418 592996 602259 604423 604497 604597 604608 613287 619466 620164 625801 648204 653447 665971 670717 690831 692237 719074 722512 724268 725583 730352 740277 766911 770199 784307 789494 792533 806323 808472 814429 818235 826844 ] |
||||||||||||||||||||||||||||||
|
17.99 ms (9.47%) |
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 474844 457902 519947 522863 502275 511856 512947 558261 555582 665971 625801 740277 604597 722512 792533 417174 420178 474674 524947 502868 486345 528474 508807 826844 428238 473453 463073 487360 452797 453824 458924 469396 472147 475895 465337 692237 648204 574298 592996 590418 602259 724268 808472 730352 448806 444745 466195 470071 454270 486355 604497 613287 482552 507284 476195 391437 502283 523565 448832 462305 462317 493127 464326 439518 493163 466561 814429 487750 525133 498623 518918 653447 589573 604608 440893 441354 818235 450250 472595 474848 476262 484762 525490 534553 537117 523562 502278 497520 559324 576695 670717 690831 719074 604423 620164 619466 789494 770199 725583 766911 784307 806323 460726 487054 495154 509964 518238 581937 188062 435695 427241 469508 466814 491403 493206 497492 518554 499851 524949 499906 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (1.67%) |
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 188062 391437 417174 420178 427241 428238 435695 439518 440893 441354 444745 448806 448832 450250 452797 453824 454270 457902 458924 460726 462305 462317 463073 464326 465337 466195 466561 466814 469396 469508 470071 472147 472595 473453 474674 474844 474848 475895 476195 476262 482552 484762 486345 486355 487054 487360 487750 491403 493127 493163 493206 495154 497492 497520 498623 499851 499906 502275 502278 502283 502868 507284 508807 509964 511856 512947 518238 518554 518918 519947 522863 523562 523565 524947 524949 525133 525490 528474 534553 537117 555582 558261 559324 574298 576695 581937 589573 590418 592996 602259 604423 604497 604597 604608 613287 619466 620164 625801 648204 653447 665971 670717 690831 692237 719074 722512 724268 725583 730352 740277 766911 770199 784307 789494 792533 806323 808472 814429 818235 826844 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal saggy hairy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал saggy волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал saggy волосатая"
]
|
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.