Query Metrics
7
Database Queries
7
Different statements
170.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.91 ms (83.26%) |
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 205809 252608 382456 384503 385228 387315 387857 393738 393771 394187 398731 399230 400446 400449 400452 400718 401996 403060 435612 443967 473322 512043 515177 515254 530358 530362 530961 539166 541912 544241 545529 549290 549991 557330 562518 564440 566509 566518 569959 571209 574589 577198 605307 609207 621620 628143 628303 628330 629991 630780 641439 656474 657270 658367 664309 665128 665271 665431 665883 673260 675499 676453 676473 676924 676982 678011 681213 682180 683546 683563 684205 684980 685587 685664 686063 686073 687488 693410 694132 696163 701406 701501 706912 708082 709578 712825 714390 714455 716078 722114 722662 722717 730575 730851 734832 738256 739670 739737 744293 744320 745445 747573 748574 759600 761390 764775 775816 789038 789433 808177 808762 812010 816797 819373 820125 823802 824617 827572 828022 828283 ] |
||||||||||||||||||||||||||||||
|
18.29 ms (10.73%) |
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 744320 745445 734832 744293 747573 701406 722662 775816 400718 403060 393771 400449 394187 435612 387315 828022 828283 530358 541912 684205 712825 630780 628330 641439 764775 738256 789433 398731 819373 823802 827572 824617 820125 539166 530362 530961 515254 544241 549290 577198 657270 665883 685664 686063 696163 714390 658367 678011 682180 683563 685587 687488 656474 722114 549991 557330 609207 628143 628303 629991 605307 789038 808177 808762 748574 812010 730851 739670 761390 730575 739737 759600 621620 387857 384503 385228 205809 252608 393738 382456 400452 399230 400446 401996 443967 816797 473322 515177 512043 562518 564440 566509 566518 569959 574589 545529 571209 673260 675499 676924 686073 693410 706912 709578 714455 665128 665431 676473 683546 684980 701501 708082 722717 664309 665271 676453 676982 681213 694132 716078 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.05%) |
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 205809 252608 382456 384503 385228 387315 387857 393738 393771 394187 398731 399230 400446 400449 400452 400718 401996 403060 435612 443967 473322 512043 515177 515254 530358 530362 530961 539166 541912 544241 545529 549290 549991 557330 562518 564440 566509 566518 569959 571209 574589 577198 605307 609207 621620 628143 628303 628330 629991 630780 641439 656474 657270 658367 664309 665128 665271 665431 665883 673260 675499 676453 676473 676924 676982 678011 681213 682180 683546 683563 684205 684980 685587 685664 686063 686073 687488 693410 694132 696163 701406 701501 706912 708082 709578 712825 714390 714455 716078 722114 722662 722717 730575 730851 734832 738256 739670 739737 744293 744320 745445 747573 748574 759600 761390 764775 775816 789038 789433 808177 808762 812010 816797 819373 820125 823802 824617 827572 828022 828283 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young teens"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young teens"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young teens"
]
|
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.