Query Metrics
7
Database Queries
7
Different statements
172.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.01 ms (84.78%) |
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 282010 408601 413944 414357 414976 416365 425118 425351 425709 429088 429805 429943 432243 443090 443480 447152 451620 453067 462470 464168 468010 468433 468628 473722 474621 486788 491256 491270 492364 493235 493963 494620 498830 508156 508189 510394 513358 518467 523206 524183 527428 530489 531257 531272 532779 532984 534842 534995 535006 535631 535644 536586 536618 536650 536653 537903 538803 540404 541846 541895 542198 543877 545341 545441 545608 547366 551223 554472 558432 558447 560941 565102 565241 578139 582323 583675 583960 586596 591612 597028 599868 599902 599961 600295 600350 600352 623205 630522 631193 632614 632641 632979 633768 633775 637008 641667 642691 642775 644962 645238 647355 648816 648871 650158 651147 666874 666897 676025 676107 677801 678028 678127 678161 679016 679314 679799 680203 696203 702164 731665 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (9.47%) |
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 468433 558432 408601 429088 413944 429943 447152 451620 453067 473722 532779 498830 535644 542198 547366 578139 541895 554472 583675 678161 678028 560941 565102 599902 600295 642775 425118 493235 493963 535631 443090 531272 508189 535006 534995 545441 582323 541846 545608 583960 679016 648816 678127 680203 630522 597028 642691 586596 623205 632614 632979 425351 513358 491270 508156 282010 534842 524183 545341 679314 637008 632641 429805 536653 551223 647355 650158 591612 599961 633775 432243 443480 416365 644962 486788 531257 536618 530489 536586 536650 494620 527428 532984 540404 543877 558447 645238 666874 676025 677801 679799 696203 702164 648871 651147 666897 676107 565241 600350 600352 599868 641667 731665 631193 633768 425709 474621 468628 518467 510394 491256 414976 538803 414357 462470 468010 492364 523206 537903 464168 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.00%) |
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 282010 408601 413944 414357 414976 416365 425118 425351 425709 429088 429805 429943 432243 443090 443480 447152 451620 453067 462470 464168 468010 468433 468628 473722 474621 486788 491256 491270 492364 493235 493963 494620 498830 508156 508189 510394 513358 518467 523206 524183 527428 530489 531257 531272 532779 532984 534842 534995 535006 535631 535644 536586 536618 536650 536653 537903 538803 540404 541846 541895 542198 543877 545341 545441 545608 547366 551223 554472 558432 558447 560941 565102 565241 578139 582323 583675 583960 586596 591612 597028 599868 599902 599961 600295 600350 600352 623205 630522 631193 632614 632641 632979 633768 633775 637008 641667 642691 642775 644962 645238 647355 648816 648871 650158 651147 666874 666897 676025 676107 677801 678028 678127 678161 679016 679314 679799 680203 696203 702164 731665 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc skinny anal"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc худые анал"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc худые анал"
]
|
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.