Query Metrics
7
Database Queries
7
Different statements
154.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.44 ms (82.59%) |
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 340635 381930 389966 390204 391437 391692 391911 391984 391992 392007 395628 401127 405028 405070 405105 405222 409083 411704 411717 411736 411747 413460 414133 414341 416000 418440 418521 418522 419523 419619 420178 422354 424410 424460 427241 428174 428238 429888 429890 429895 429916 441203 441354 441784 441848 442064 443554 447094 450281 451464 453409 454277 460289 462305 464373 464936 466015 466561 467034 468955 472630 473249 473391 474818 476343 478525 479765 483375 484645 484762 486341 489299 489868 491436 491769 493083 493163 494233 494978 496063 496554 507284 508575 510898 512947 513130 515063 518957 520682 522592 522768 523358 523565 525490 528474 536639 541055 557327 559344 569302 581098 581126 581937 582443 590418 604737 646243 647885 665971 678791 678795 703942 724268 740277 748253 753023 766613 776217 808166 824791 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (11.22%) |
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 582443 391984 418440 483375 405105 479765 491436 604737 416000 703942 491769 447094 557327 748253 424410 405070 496063 395628 581098 389966 467034 508575 808166 753023 340635 409083 522592 443554 824791 512947 665971 740277 420178 429916 411704 528474 413460 581126 478525 489299 391437 474818 391911 411747 428238 428174 590418 724268 392007 414133 381930 766613 507284 489868 581937 441354 484762 525490 391992 462305 476343 523358 411717 427241 513130 520682 646243 429890 493083 523565 466561 419523 466015 484645 522768 776217 493163 494978 401127 411736 464373 464936 473249 429895 450281 678795 494233 391692 441784 515063 541055 569302 678791 405222 418522 460289 429888 559344 468955 496554 441203 405028 486341 390204 472630 647885 422354 451464 442064 473391 441848 510898 418521 419619 414341 454277 518957 536639 424460 453409 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.81%) |
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 340635 381930 389966 390204 391437 391692 391911 391984 391992 392007 395628 401127 405028 405070 405105 405222 409083 411704 411717 411736 411747 413460 414133 414341 416000 418440 418521 418522 419523 419619 420178 422354 424410 424460 427241 428174 428238 429888 429890 429895 429916 441203 441354 441784 441848 442064 443554 447094 450281 451464 453409 454277 460289 462305 464373 464936 466015 466561 467034 468955 472630 473249 473391 474818 476343 478525 479765 483375 484645 484762 486341 489299 489868 491436 491769 493083 493163 494233 494978 496063 496554 507284 508575 510898 512947 513130 515063 518957 520682 522592 522768 523358 523565 525490 528474 536639 541055 557327 559344 569302 581098 581126 581937 582443 590418 604737 646243 647885 665971 678791 678795 703942 724268 740277 748253 753023 766613 776217 808166 824791 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal hairy chubby"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал волосатая chubby"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал волосатая chubby"
]
|
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.