Query Metrics
7
Database Queries
7
Different statements
158.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.67 ms (83.33%) |
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 481256 485854 533052 535771 541970 543539 543752 544099 544161 544173 545646 545875 546327 547818 549602 553023 558253 562923 566369 570375 576251 578758 584844 586696 586714 586732 588795 597093 601409 607110 612656 616925 617249 619541 620696 622904 623036 635292 648965 651751 651760 652996 653039 653335 653550 654662 657394 657421 658305 658424 658703 659091 659641 659647 660466 661453 662790 664165 664768 665956 666399 672286 673156 674277 675602 678815 679554 683458 684406 687949 688866 688939 689971 691960 693350 693918 695334 695407 695424 695741 697598 699938 703740 704996 705009 705104 705647 712659 714831 716273 722350 722957 723136 723249 776770 778678 778772 779349 780712 780852 781149 782118 782173 786818 787977 789162 789428 789890 793958 794874 795592 795644 795668 797131 799531 799780 799807 800280 805091 805317 ] |
||||||||||||||||||||||||||||||
|
15.53 ms (9.83%) |
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 533052 535771 481256 485854 543539 545646 549602 566369 576251 543752 544099 544173 541970 544161 545875 546327 562923 651751 654662 659641 664165 664768 679554 688939 703740 712659 714831 716273 723249 648965 651760 652996 653039 657394 657421 658305 658424 659091 659647 660466 662790 665956 666399 672286 674277 675602 678815 683458 687949 688866 689971 691960 693350 693918 695407 695424 697598 704996 705009 705104 722350 653335 653550 658703 661453 673156 684406 695334 695741 699938 705647 722957 723136 547818 553023 558253 570375 578758 584844 607110 622904 586714 588795 612656 620696 623036 635292 586732 597093 601409 617249 619541 586696 616925 776770 778678 778772 779349 780712 780852 781149 782118 782173 786818 787977 789162 789428 789890 793958 794874 795592 795644 795668 797131 799531 799780 799807 800280 805091 805317 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.88%) |
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 481256 485854 533052 535771 541970 543539 543752 544099 544161 544173 545646 545875 546327 547818 549602 553023 558253 562923 566369 570375 576251 578758 584844 586696 586714 586732 588795 597093 601409 607110 612656 616925 617249 619541 620696 622904 623036 635292 648965 651751 651760 652996 653039 653335 653550 654662 657394 657421 658305 658424 658703 659091 659641 659647 660466 661453 662790 664165 664768 665956 666399 672286 673156 674277 675602 678815 679554 683458 684406 687949 688866 688939 689971 691960 693350 693918 695334 695407 695424 695741 697598 699938 703740 704996 705009 705104 705647 712659 714831 716273 722350 722957 723136 723249 776770 778678 778772 779349 780712 780852 781149 782118 782173 786818 787977 789162 789428 789890 793958 794874 795592 795644 795668 797131 799531 799780 799807 800280 805091 805317 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск dogging"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск dogging"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian dogging"
]
|
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.