Query Metrics
7
Database Queries
7
Different statements
173.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.46 ms (84.04%) |
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 21143 82281 122846 162863 163006 163310 167822 383735 389525 390614 398461 400854 404841 409949 415847 417373 425300 427494 428870 429541 429544 431716 432337 435645 435658 444822 445081 445765 446855 448346 460938 463755 469549 473372 475804 475812 482242 492410 492414 498620 510577 512172 515749 515883 515891 519904 519907 520144 523222 525193 530238 532941 550608 550615 550618 550727 550735 550748 550752 550763 550764 551012 551979 551992 552001 552043 552054 552895 552912 552919 552933 552935 554426 554789 556362 556375 556397 558367 559864 559877 559886 559902 565161 565468 565471 565995 566011 579347 583417 590919 590959 590978 592422 595945 595952 606699 619411 619412 619432 622601 622620 622650 623601 623608 623619 623813 623815 650810 651536 673044 673048 694194 695183 714119 721532 727334 760946 795437 797788 816132 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (10.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 550764 552919 565468 550752 550748 550763 552043 623619 619411 398461 444822 429544 445765 463755 552895 552912 552933 559902 694194 556362 606699 619432 623601 515891 565471 469549 482242 460938 515883 427494 530238 559864 163310 519904 556397 559886 622601 515749 82281 448346 475812 520144 556375 673048 623608 435658 552935 550727 579347 650810 619412 760946 122846 400854 428870 551992 498620 795437 492414 550618 435645 673044 519907 623813 714119 415847 446855 525193 532941 510577 552001 590919 623815 727334 622650 409949 523222 512172 417373 429541 550608 475804 651536 583417 550615 558367 559877 445081 550735 554426 695183 595952 595945 404841 21143 432337 551012 590959 590978 425300 721532 592422 797788 565995 622620 431716 162863 383735 552054 492410 163006 167822 551979 554789 565161 473372 566011 390614 389525 816132 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.55%) |
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 21143 82281 122846 162863 163006 163310 167822 383735 389525 390614 398461 400854 404841 409949 415847 417373 425300 427494 428870 429541 429544 431716 432337 435645 435658 444822 445081 445765 446855 448346 460938 463755 469549 473372 475804 475812 482242 492410 492414 498620 510577 512172 515749 515883 515891 519904 519907 520144 523222 525193 530238 532941 550608 550615 550618 550727 550735 550748 550752 550763 550764 551012 551979 551992 552001 552043 552054 552895 552912 552919 552933 552935 554426 554789 556362 556375 556397 558367 559864 559877 559886 559902 565161 565468 565471 565995 566011 579347 583417 590919 590959 590978 592422 595945 595952 606699 619411 619412 619432 622601 622620 622650 623601 623608 623619 623813 623815 650810 651536 673044 673048 694194 695183 714119 721532 727334 760946 795437 797788 816132 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"japanese licking"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"японк азиатк лиза"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.87%) |
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.