Query Metrics
7
Database Queries
7
Different statements
134.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.00 ms (84.70%) |
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 549502 553881 554948 555573 561150 563412 568086 569871 570390 570641 570851 571159 571390 572746 572796 578979 580050 583652 585804 585845 585899 586422 586666 587243 587723 588147 588448 588843 589276 589330 589702 590033 590211 590463 591615 591955 592419 593263 595545 595679 595705 595743 595800 596182 596587 596995 598587 598611 598728 598796 599276 599445 600319 600470 600516 600583 600626 600874 601105 601612 603727 604793 605145 605316 605547 605625 607084 607092 607301 609107 609808 610693 614019 614183 616425 616745 618375 619112 620029 620305 620649 620791 621652 621811 622996 630134 630852 640522 647697 652979 654419 654810 654844 655583 655718 655752 656728 657309 657642 658008 658323 660140 660934 661693 661698 665931 669708 670495 676995 682929 697023 698101 702432 703604 716000 716006 716502 722888 723411 723428 ] |
||||||||||||||||||||||||||||||
|
11.74 ms (8.73%) |
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 682929 702432 703604 722888 647697 652979 654419 654810 654844 655583 655718 655752 656728 657309 657642 658008 658323 660140 660934 661693 661698 665931 669708 670495 676995 697023 698101 716000 716006 716502 723411 723428 549502 553881 554948 555573 561150 563412 568086 569871 570390 570641 570851 571159 571390 572746 572796 578979 580050 583652 586422 587243 588448 589702 590033 590211 590463 595545 596182 598796 599276 599445 600319 600874 601612 607092 607301 609808 610693 614019 616745 620305 620649 622996 630134 640522 585845 587723 588147 589276 589330 591955 595679 595705 595743 595800 596587 598728 600516 600583 603727 605145 605316 605625 607084 609107 614183 618375 621652 621811 585804 592419 593263 596995 598587 598611 600470 600626 601105 604793 605547 616425 619112 620029 620791 630852 585899 586666 588843 591615 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.93%) |
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 549502 553881 554948 555573 561150 563412 568086 569871 570390 570641 570851 571159 571390 572746 572796 578979 580050 583652 585804 585845 585899 586422 586666 587243 587723 588147 588448 588843 589276 589330 589702 590033 590211 590463 591615 591955 592419 593263 595545 595679 595705 595743 595800 596182 596587 596995 598587 598611 598728 598796 599276 599445 600319 600470 600516 600583 600626 600874 601105 601612 603727 604793 605145 605316 605547 605625 607084 607092 607301 609107 609808 610693 614019 614183 616425 616745 618375 619112 620029 620305 620649 620791 621652 621811 622996 630134 630852 640522 647697 652979 654419 654810 654844 655583 655718 655752 656728 657309 657642 658008 658323 660140 660934 661693 661698 665931 669708 670495 676995 682929 697023 698101 702432 703604 716000 716006 716502 722888 723411 723428 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"butt hair"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"butt hair"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"butt hair"
]
|
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.