Query Metrics
7
Database Queries
7
Different statements
146.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.61 ms (82.57%) |
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 20051 20948 22861 24149 82281 122846 208999 213273 385471 397867 420211 421038 423761 428870 431672 435611 435644 435645 435658 446481 448346 456847 457264 460938 462807 475812 481376 482242 487779 492414 510574 510579 510580 510585 515891 516811 519904 519907 519909 519914 520144 520629 524492 530348 533295 534198 543919 546038 546522 550643 550723 550727 551992 551994 551997 552005 552017 552021 552024 552042 552913 552933 552935 556373 556375 556379 557208 559869 559926 563883 564215 565471 569804 576496 583280 586624 614597 619417 619441 619445 619452 620962 622622 622633 622652 622653 622655 622656 623510 623606 623608 623622 623813 623817 625915 629111 639310 643146 643447 643520 646457 648794 650810 673048 711286 712182 718961 730906 735852 737105 737162 740362 740764 742480 744249 760946 766626 767285 788257 814198 ] |
||||||||||||||||||||||||||||||
|
15.66 ms (10.72%) |
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 559869 481376 564215 519904 814198 448346 520629 530348 552005 623608 730906 543919 551997 563883 620962 557208 552021 619441 622656 423761 208999 552933 552017 718961 740764 737162 742480 20948 550643 482242 460938 487779 712182 533295 520144 673048 767285 431672 559926 556373 546522 622633 556379 648794 550723 385471 456847 550727 619452 629111 711286 510585 646457 515891 519907 397867 435658 552935 569804 586624 619417 622622 625915 740362 760946 623510 623606 462807 492414 565471 623813 435645 766626 519914 623817 82281 475812 510574 534198 552042 556375 552913 639310 737105 735852 510579 122846 420211 428870 551992 546038 457264 446481 519909 623622 213273 421038 510580 551994 650810 552024 622652 619445 622655 614597 622653 788257 524492 576496 643447 435611 516811 435644 583280 20051 643146 643520 744249 24149 22861 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.85%) |
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 20051 20948 22861 24149 82281 122846 208999 213273 385471 397867 420211 421038 423761 428870 431672 435611 435644 435645 435658 446481 448346 456847 457264 460938 462807 475812 481376 482242 487779 492414 510574 510579 510580 510585 515891 516811 519904 519907 519909 519914 520144 520629 524492 530348 533295 534198 543919 546038 546522 550643 550723 550727 551992 551994 551997 552005 552017 552021 552024 552042 552913 552933 552935 556373 556375 556379 557208 559869 559926 563883 564215 565471 569804 576496 583280 586624 614597 619417 619441 619445 619452 620962 622622 622633 622652 622653 622655 622656 623510 623606 623608 623622 623813 623817 625915 629111 639310 643146 643447 643520 646457 648794 650810 673048 711286 712182 718961 730906 735852 737105 737162 740362 740764 742480 744249 760946 766626 767285 788257 814198 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls japanese"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк японк азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.