Query Metrics
7
Database Queries
7
Different statements
179.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.74 ms (80.15%) |
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 46580 323119 400862 418941 425970 426686 429010 430377 443776 452115 452516 454267 454658 456034 457866 460588 460744 462319 463173 464342 464781 464949 465525 466097 466243 466273 466313 466821 466941 468682 468958 470662 470771 470933 472641 473176 474085 474391 474394 475051 476288 478918 479058 482367 484711 484981 485216 485355 485405 485812 485977 486173 486788 487339 491913 494064 496548 500674 503569 504414 507170 513477 513510 516093 517052 523049 525691 531316 535025 536655 544500 546114 551966 552307 552989 559569 563021 566387 567338 568383 571216 589079 592900 595729 596477 596551 600407 603507 613432 613495 617621 626138 629658 640676 665182 688604 697797 703051 709854 715556 716405 721187 725451 727799 728194 728930 728931 748227 774613 797119 801363 801377 805896 807993 810980 810981 811792 811872 818439 818456 ] |
||||||||||||||||||||||||||||||
|
22.35 ms (12.46%) |
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 475051 566387 551966 568383 665182 703051 716405 721187 688604 715556 552989 589079 595729 596477 603507 626138 629658 592900 801363 801377 774613 797119 805896 725451 807993 810981 811792 727799 728931 613432 613495 640676 697797 709854 810980 811872 464781 472641 473176 474085 400862 463173 468682 478918 430377 468958 479058 443776 470771 485405 500674 486173 484981 485355 485977 494064 507170 426686 418941 531316 470662 571216 748227 323119 425970 452115 454658 464342 466821 460588 474391 486788 504414 517052 503569 496548 536655 476288 482367 544500 552307 559569 563021 596551 617621 728930 728194 460744 466313 474394 462319 466273 454267 466243 485216 513477 484711 513510 525691 491913 487339 516093 535025 465525 567338 466097 600407 523049 546114 46580 429010 818439 818456 457866 485812 452516 456034 464949 466941 470933 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (2.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.06%) |
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 46580 323119 400862 418941 425970 426686 429010 430377 443776 452115 452516 454267 454658 456034 457866 460588 460744 462319 463173 464342 464781 464949 465525 466097 466243 466273 466313 466821 466941 468682 468958 470662 470771 470933 472641 473176 474085 474391 474394 475051 476288 478918 479058 482367 484711 484981 485216 485355 485405 485812 485977 486173 486788 487339 491913 494064 496548 500674 503569 504414 507170 513477 513510 516093 517052 523049 525691 531316 535025 536655 544500 546114 551966 552307 552989 559569 563021 566387 567338 568383 571216 589079 592900 595729 596477 596551 600407 603507 613432 613495 617621 626138 629658 640676 665182 688604 697797 703051 709854 715556 716405 721187 725451 727799 728194 728930 728931 748227 774613 797119 801363 801377 805896 807993 810980 810981 811792 811872 818439 818456 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature 69 position"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature поз position 69"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature поз position 69"
]
|
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.