Query Metrics
7
Database Queries
7
Different statements
146.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.97 ms (81.90%) |
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 13011 14232 14700 14711 31218 33755 59007 70852 75936 78536 78637 78926 79082 79331 102626 130054 146523 189230 238809 304063 306045 308331 325648 328446 342269 353299 378272 383088 386198 386743 390508 390857 391144 395398 395405 395406 395450 397519 398240 398518 398828 399222 399355 399717 404124 405979 408611 410956 412858 415115 417053 417113 417929 418052 418453 418897 419358 419808 420203 420614 421250 421743 425125 425587 425601 435715 443661 444442 445601 445741 446976 449353 452228 452601 453590 457240 457401 459012 459226 460079 461044 463894 464146 464147 467028 468352 468423 471859 475821 477801 478556 483251 483457 486268 491239 493808 494997 502179 518438 518587 522140 527988 530557 530587 558432 558657 567208 574460 584749 598178 602010 648906 655358 705793 712776 716065 732753 738648 747879 758829 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (11.04%) |
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 460079 486268 417929 527988 59007 558432 342269 189230 398240 78536 397519 558657 648906 102626 75936 390857 79331 452601 574460 14711 398518 449353 33755 238809 390508 483251 443661 417053 452228 415115 419358 705793 732753 475821 325648 404124 425587 602010 420614 420203 418453 395398 14700 453590 491239 494997 598178 79082 391144 395405 478556 383088 78637 378272 530587 353299 518438 70852 412858 386198 306045 655358 399717 421250 446976 13011 304063 399222 418052 738648 130054 419808 518587 464147 584749 308331 425601 468423 328446 395450 408611 417113 467028 483457 461044 31218 398828 418897 445741 463894 522140 471859 395406 399355 425125 464146 386743 444442 459226 468352 445601 477801 530557 716065 747879 502179 14232 567208 405979 712776 457240 758829 146523 78926 421743 410956 435715 457401 459012 493808 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.16%) |
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 13011 14232 14700 14711 31218 33755 59007 70852 75936 78536 78637 78926 79082 79331 102626 130054 146523 189230 238809 304063 306045 308331 325648 328446 342269 353299 378272 383088 386198 386743 390508 390857 391144 395398 395405 395406 395450 397519 398240 398518 398828 399222 399355 399717 404124 405979 408611 410956 412858 415115 417053 417113 417929 418052 418453 418897 419358 419808 420203 420614 421250 421743 425125 425587 425601 435715 443661 444442 445601 445741 446976 449353 452228 452601 453590 457240 457401 459012 459226 460079 461044 463894 464146 464147 467028 468352 468423 471859 475821 477801 478556 483251 483457 486268 491239 493808 494997 502179 518438 518587 522140 527988 530557 530587 558432 558657 567208 574460 584749 598178 602010 648906 655358 705793 712776 716065 732753 738648 747879 758829 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жена изменяет с негра%…"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен жен чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
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.