Query Metrics
7
Database Queries
7
Different statements
143.88 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.62 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.33 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young black cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.67 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 403579 472151 448692 474852 503828 548570 571269 584212 663895 565372 592358 604083 593260 445514 249637 404829 396609 449868 468009 637123 527611 516686 517184 564596 605105 628082 502703 465649 400753 401203 405507 413263 466968 532804 532441 565149 646875 556533 808077 453473 500669 417328 560197 545611 566786 571016 586681 550960 384524 383987 411227 416165 452228 452282 457163 521367 574559 574410 589674 458986 480929 494345 464453 491497 528586 536752 395503 480429 494269 545614 557236 637074 620205 527273 647932 449869 450836 381752 532766 522478 448810 562894 639732 425490 518438 533746 584708 478672 ] |
||||||||||||||||||||||||||||||
| 4 | 2.82 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 249637 381752 383987 384524 395503 396609 400753 401203 403579 404829 405507 411227 413263 416165 417328 425490 445514 448692 448810 449868 449869 450836 452228 452282 453473 457163 458986 464453 465649 466968 468009 472151 474852 478672 480429 480929 491497 494269 494345 500669 502703 503828 516686 517184 518438 521367 522478 527273 527611 528586 532441 532766 532804 533746 536752 545611 545614 548570 550960 556533 557236 560197 562894 564596 565149 565372 566786 571016 571269 574410 574559 584212 584708 586681 589674 592358 593260 604083 605105 620205 628082 637074 637123 639732 646875 647932 663895 808077 ] |
||||||||||||||||||||||||||||||
| 5 | 117.23 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 249637 381752 383987 384524 395503 396609 400753 401203 403579 404829 405507 411227 413263 416165 417328 425490 445514 448692 448810 449868 449869 450836 452228 452282 453473 457163 458986 464453 465649 466968 468009 472151 474852 478672 480429 480929 491497 494269 494345 500669 502703 503828 516686 517184 518438 521367 522478 527273 527611 528586 532441 532766 532804 533746 536752 545611 545614 548570 550960 556533 557236 560197 562894 564596 565149 565372 566786 571016 571269 574410 574559 584212 584708 586681 589674 592358 593260 604083 605105 620205 628082 637074 637123 639732 646875 647932 663895 808077 ] |
||||||||||||||||||||||||||||||
| 6 | 1.77 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young black cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young black 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.