Query Metrics
7
Database Queries
7
Different statements
201.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.64 ms (87.08%) |
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 21323 167756 384492 387143 387647 390207 396784 396922 396989 397145 397678 398354 399738 402020 411880 414248 416294 419951 421038 423688 427449 428849 429764 430468 431607 434861 435635 443523 444005 444117 446499 446855 448315 453249 454292 454685 456132 457097 457209 457732 459521 465076 469210 473756 475250 475448 477407 482330 492178 498620 507258 508962 510579 510580 510669 515749 519904 520629 525193 525197 530685 532941 540310 541840 545532 550616 550732 550739 550772 552002 554337 556400 557199 557543 558374 559160 564223 566013 567833 568552 568869 570729 572721 572740 572746 577184 577251 578499 579347 582669 590966 595705 598270 601081 604086 605397 605848 605929 611314 615005 619441 619451 619474 619487 622656 639310 648794 654451 662078 672031 672261 680892 686082 689688 712154 720948 766566 766607 795539 808775 ] |
||||||||||||||||||||||||||||||
|
16.23 ms (8.04%) |
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 414248 387647 397678 427449 454292 446499 540310 552002 558374 566013 572721 577184 582669 550772 568552 680892 550616 556400 605397 619474 390207 416294 396784 444005 443523 515749 387143 402020 568869 672031 766566 396922 444117 435635 475250 448315 465076 520629 510669 492178 554337 578499 672261 712154 654451 557543 570729 611314 619441 601081 605848 619487 622656 639310 795539 808775 423688 457097 510579 590966 498620 508962 429764 519904 598270 619451 397145 431607 419951 550732 550739 577251 689688 662078 572746 595705 604086 615005 396989 430468 477407 446855 454685 525193 532941 530685 557199 545532 686082 564223 605929 766607 720948 469210 482330 525197 384492 167756 21323 398354 399738 411880 428849 421038 434861 456132 457209 457732 453249 459521 475448 510580 507258 473756 567833 572740 579347 541840 559160 648794 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.65%) |
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 21323 167756 384492 387143 387647 390207 396784 396922 396989 397145 397678 398354 399738 402020 411880 414248 416294 419951 421038 423688 427449 428849 429764 430468 431607 434861 435635 443523 444005 444117 446499 446855 448315 453249 454292 454685 456132 457097 457209 457732 459521 465076 469210 473756 475250 475448 477407 482330 492178 498620 507258 508962 510579 510580 510669 515749 519904 520629 525193 525197 530685 532941 540310 541840 545532 550616 550732 550739 550772 552002 554337 556400 557199 557543 558374 559160 564223 566013 567833 568552 568869 570729 572721 572740 572746 577184 577251 578499 579347 582669 590966 595705 598270 601081 604086 605397 605848 605929 611314 615005 619441 619451 619474 619487 622656 639310 648794 654451 662078 672031 672261 680892 686082 689688 712154 720948 766566 766607 795539 808775 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian ass"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк жоп"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.70%) |
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.