Query Metrics
7
Database Queries
7
Different statements
402.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
376.66 ms (93.63%) |
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 123271 381785 386099 386197 389630 392055 402021 404245 415822 417071 420509 428913 437788 457412 459874 460118 466067 470960 476915 480613 484012 484096 491015 491089 500378 506432 511198 520652 526175 531962 534783 535602 540087 546907 557482 567430 571320 590625 593121 598538 599876 602662 604008 606977 608459 610285 610421 621788 631603 637437 637692 639825 640776 650662 666463 673836 673908 691737 695780 697215 698077 702179 705075 716823 717788 720304 721244 722070 722299 722996 726162 726684 732850 732995 735387 736342 742214 743527 749769 752646 753167 755578 759679 760309 762956 765915 766239 768243 768896 772005 776253 778145 778523 780760 788729 789170 789480 789537 789552 790617 793252 794811 796961 797794 801233 802766 810405 811963 813143 813168 813660 813880 815981 817243 818018 819697 820810 822825 823632 824410 ] |
||||||||||||||||||||||||||||||
|
14.08 ms (3.50%) |
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 604008 673836 789552 813168 732850 404245 459874 666463 637692 801233 789480 721244 650662 789537 780760 535602 765915 123271 457412 437788 428913 415822 491089 722070 386197 759679 520652 511198 593121 802766 726162 749769 621788 599876 818018 484096 534783 567430 702179 717788 722299 673908 790617 776253 736342 796961 797794 760309 732995 755578 766239 722996 389630 753167 788729 772005 726684 768896 631603 811963 506432 460118 470960 484012 402021 813660 820810 817243 824410 480613 526175 531962 557482 691737 695780 716823 697215 720304 590625 610421 778145 813143 762956 768243 743527 752646 639825 705075 789170 420509 500378 822825 815981 476915 381785 546907 610285 794811 735387 778523 466067 392055 417071 571320 602662 793252 810405 637437 742214 698077 606977 608459 598538 386099 640776 823632 819697 813880 491015 540087 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (0.86%) |
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 123271 381785 386099 386197 389630 392055 402021 404245 415822 417071 420509 428913 437788 457412 459874 460118 466067 470960 476915 480613 484012 484096 491015 491089 500378 506432 511198 520652 526175 531962 534783 535602 540087 546907 557482 567430 571320 590625 593121 598538 599876 602662 604008 606977 608459 610285 610421 621788 631603 637437 637692 639825 640776 650662 666463 673836 673908 691737 695780 697215 698077 702179 705075 716823 717788 720304 721244 722070 722299 722996 726162 726684 732850 732995 735387 736342 742214 743527 749769 752646 753167 755578 759679 760309 762956 765915 766239 768243 768896 772005 776253 778145 778523 780760 788729 789170 789480 789537 789552 790617 793252 794811 796961 797794 801233 802766 810405 811963 813143 813168 813660 813880 815981 817243 818018 819697 820810 822825 823632 824410 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home blowjob"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (0.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home минет оральн секс"
]
|
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.