Query Metrics
7
Database Queries
7
Different statements
186.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.92 ms (86.35%) |
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 401500 401849 401880 419452 422600 427530 469534 501641 503167 509163 523856 527412 532785 538473 541879 548548 548609 550684 551081 551223 551477 552120 552160 552267 556014 557449 558126 558131 558135 558820 558976 559140 559942 560387 561192 561652 562619 562826 562837 565162 565249 567166 568315 568324 568457 569260 569692 570708 572023 573748 574184 575806 576393 576417 583677 583725 586693 586770 586786 587864 588520 590343 591612 593729 595873 597227 597476 597550 598057 598752 599711 599921 599945 600295 600330 601579 601917 601922 602246 604289 605338 605345 605349 605952 609897 618865 620100 620641 623205 624505 625185 627804 627813 628379 628388 628406 632614 632695 632979 633114 633733 634482 634777 637003 637008 643376 644962 646007 649215 649578 659258 666874 674953 677294 688369 696212 716032 749924 759639 783468 ] |
||||||||||||||||||||||||||||||
|
17.01 ms (9.13%) |
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 597550 503167 422600 559140 568457 574184 575806 548548 551477 552160 558820 562826 649215 558976 562837 586786 599945 597227 599921 600330 600295 749924 759639 523856 527412 605952 509163 401849 561192 659258 590343 634482 637008 597476 599711 568315 572023 551081 583677 556014 562619 565162 595873 633733 623205 628406 632614 632979 593729 633114 501641 538473 588520 604289 601922 469534 605349 602246 568324 570708 551223 591612 598752 634777 576417 620641 587864 620100 601917 637003 625185 783468 609897 644962 532785 541879 552267 558126 558135 560387 548609 550684 557449 565249 552120 559942 569692 576393 666874 716032 624505 598057 601579 605345 632695 627804 628379 628388 643376 605338 627813 419452 401500 401880 427530 567166 569260 573748 558131 561652 646007 674953 677294 696212 649578 688369 583725 586693 586770 618865 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.43%) |
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 401500 401849 401880 419452 422600 427530 469534 501641 503167 509163 523856 527412 532785 538473 541879 548548 548609 550684 551081 551223 551477 552120 552160 552267 556014 557449 558126 558131 558135 558820 558976 559140 559942 560387 561192 561652 562619 562826 562837 565162 565249 567166 568315 568324 568457 569260 569692 570708 572023 573748 574184 575806 576393 576417 583677 583725 586693 586770 586786 587864 588520 590343 591612 593729 595873 597227 597476 597550 598057 598752 599711 599921 599945 600295 600330 601579 601917 601922 602246 604289 605338 605345 605349 605952 609897 618865 620100 620641 623205 624505 625185 627804 627813 628379 628388 628406 632614 632695 632979 633114 633733 634482 634777 637003 637008 643376 644962 646007 649215 649578 659258 666874 674953 677294 688369 696212 716032 749924 759639 783468 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful butt anal"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая butt анал"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.69%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая butt анал"
]
|
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.