Query Metrics
7
Database Queries
7
Different statements
172.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.21 ms (83.48%) |
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 418645 420516 423209 433038 433040 433047 433382 433391 449360 458197 471780 473129 476225 476564 481323 485140 489160 489183 492136 492137 493264 493825 500955 507111 508138 509591 513843 517709 518938 519589 520474 521763 521807 522010 525513 526601 527910 528146 528816 529184 533290 539857 542224 542578 543022 543794 543929 546113 546119 551933 559315 559345 559356 566563 569947 569956 570148 570426 570747 575710 577101 580201 580866 581124 582297 582371 583541 585328 588005 588603 588620 589664 589685 590265 590344 590968 590975 591750 592318 592363 592364 593247 596925 596956 596966 600464 600804 610110 610148 614041 614376 615145 615428 616100 618575 619571 625805 630092 660457 667253 670564 716965 716974 716980 717274 728134 736226 738125 738636 742043 749520 760068 772001 776488 787867 788132 796822 801234 803164 814399 ] |
||||||||||||||||||||||||||||||
|
17.77 ms (10.28%) |
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 738636 742043 749520 728134 738125 772001 610110 610148 616100 625805 716974 776488 787867 803164 500955 517709 518938 513843 551933 582297 423209 814399 489160 481323 492136 492137 493264 520474 521763 528816 507111 543022 559315 577101 543929 566563 580866 559345 559356 581124 583541 717274 667253 590265 596925 614376 588005 588603 589664 592364 593247 591750 630092 760068 801234 736226 716965 796822 418645 473129 508138 522010 525513 527910 433382 476564 493825 539857 542224 546113 570747 542578 546119 569947 570148 569956 660457 716980 585328 589685 590975 596966 590968 615428 596956 590344 600464 600804 485140 489183 575710 582371 433038 420516 476225 526601 543794 570426 592363 592318 588620 788132 615145 618575 471780 433391 458197 449360 533290 529184 509591 580201 614041 433047 433040 519589 528146 521807 670564 619571 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (2.01%) |
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 418645 420516 423209 433038 433040 433047 433382 433391 449360 458197 471780 473129 476225 476564 481323 485140 489160 489183 492136 492137 493264 493825 500955 507111 508138 509591 513843 517709 518938 519589 520474 521763 521807 522010 525513 526601 527910 528146 528816 529184 533290 539857 542224 542578 543022 543794 543929 546113 546119 551933 559315 559345 559356 566563 569947 569956 570148 570426 570747 575710 577101 580201 580866 581124 582297 582371 583541 585328 588005 588603 588620 589664 589685 590265 590344 590968 590975 591750 592318 592363 592364 593247 596925 596956 596966 600464 600804 610110 610148 614041 614376 615145 615428 616100 618575 619571 625805 630092 660457 667253 670564 716965 716974 716980 717274 728134 736226 738125 738636 742043 749520 760068 772001 776488 787867 788132 796822 801234 803164 814399 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx indian"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx indian"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx indian"
]
|
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.