Query Metrics
7
Database Queries
7
Different statements
198.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.41 ms (83.83%) |
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 404766 405156 406075 413274 427344 428640 436742 439816 444679 451943 453529 459388 460212 466014 466103 469424 471953 472155 472161 472384 478372 481269 482243 485462 486569 490418 493176 494036 495230 496100 496575 500241 509714 512843 514307 515807 516119 516890 518865 520124 521832 525651 526775 531067 533622 540689 546688 547525 548254 549845 550744 552029 552940 553031 557039 560114 560189 560731 562644 563580 564453 564687 565105 565235 566330 566370 568822 569602 570998 573390 574244 574715 575447 576308 584461 586406 587130 588250 588730 588801 590427 590992 591510 593198 595217 598073 598724 599008 602483 602574 602841 603885 603900 603981 604364 607797 608206 608820 609259 609649 611375 613275 617040 619107 620263 623321 623813 625212 625322 625770 627139 636519 651877 652981 653524 654312 662382 663259 673349 677007 ] |
||||||||||||||||||||||||||||||
|
24.13 ms (12.15%) |
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 566330 466103 451943 482243 485462 546688 549845 652981 598073 436742 439816 472384 453529 540689 548254 590992 428640 515807 495230 526775 590427 617040 490418 493176 520124 481269 512843 603900 466014 494036 521832 673349 663259 444679 677007 625770 496100 636519 478372 566370 651877 588250 588801 602574 608820 587130 593198 552940 654312 662382 599008 623813 623321 427344 472155 509714 550744 560731 602483 405156 533622 565235 613275 459388 516119 569602 565105 564453 591510 602841 471953 500241 531067 573390 514307 575447 564687 603981 496575 653524 560189 609259 472161 560114 574244 603885 516890 627139 625322 460212 404766 525651 563580 568822 574715 595217 406075 576308 607797 609649 469424 486569 547525 552029 598724 586406 608206 413274 518865 562644 553031 570998 557039 584461 588730 611375 619107 620263 604364 625212 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.41%) |
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 404766 405156 406075 413274 427344 428640 436742 439816 444679 451943 453529 459388 460212 466014 466103 469424 471953 472155 472161 472384 478372 481269 482243 485462 486569 490418 493176 494036 495230 496100 496575 500241 509714 512843 514307 515807 516119 516890 518865 520124 521832 525651 526775 531067 533622 540689 546688 547525 548254 549845 550744 552029 552940 553031 557039 560114 560189 560731 562644 563580 564453 564687 565105 565235 566330 566370 568822 569602 570998 573390 574244 574715 575447 576308 584461 586406 587130 588250 588730 588801 590427 590992 591510 593198 595217 598073 598724 599008 602483 602574 602841 603885 603900 603981 604364 607797 608206 608820 609259 609649 611375 613275 617040 619107 620263 623321 623813 625212 625322 625770 627139 636519 651877 652981 653524 654312 662382 663259 673349 677007 ] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс утро"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.13 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс утр"
]
|
||||||||||||||||||||||||||||||
|
1.06 ms (0.53%) |
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.