Query Metrics
7
Database Queries
7
Different statements
170.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.46 ms (83.46%) |
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 396286 417336 418706 419383 420028 420233 421544 424617 424996 434588 448524 457141 459234 459801 462854 464872 468591 471727 471990 474613 495358 500266 509399 514483 533207 535637 538986 539197 541393 541724 543727 544019 547380 549086 549091 549098 552622 552921 555807 556521 562769 567082 568731 570721 572954 576445 576990 580735 584721 588190 593594 594272 594429 594503 595536 598433 600132 600805 601970 602802 603603 604371 605437 610965 629171 655281 658173 658555 662148 683303 683341 686576 715808 731978 740860 748192 750334 756269 758979 762980 765659 766076 767125 769848 774022 777410 780243 780650 787611 789838 790542 795490 795555 797204 800523 801916 802552 802952 804327 805536 807669 809121 810512 811632 813285 814237 814527 814959 815092 815132 818516 818518 818527 818544 821445 821553 821716 823092 823529 827858 ] |
||||||||||||||||||||||||||||||
|
18.81 ms (11.02%) |
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 419383 594503 462854 417336 629171 748192 421544 821445 814237 818516 823529 821553 509399 538986 543727 547380 562769 549091 658173 683341 683303 655281 658555 594429 600805 604371 795555 801916 810512 813285 787611 811632 802952 756269 766076 767125 774022 740860 765659 715808 795490 802552 804327 420233 464872 539197 777410 662148 572954 552921 567082 541724 541393 570721 576990 549086 552622 588190 600132 758979 459234 544019 555807 420028 533207 818527 459801 457141 500266 495358 731978 815132 576445 602802 605437 780650 424617 814527 818544 814959 823092 815092 818518 821716 827858 448524 514483 535637 556521 584721 549098 580735 610965 593594 598433 603603 594272 601970 595536 790542 797204 800523 789838 807669 809121 762980 769848 750334 780243 805536 434588 418706 396286 424996 471990 468591 471727 474613 568731 686576 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.51%) |
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 396286 417336 418706 419383 420028 420233 421544 424617 424996 434588 448524 457141 459234 459801 462854 464872 468591 471727 471990 474613 495358 500266 509399 514483 533207 535637 538986 539197 541393 541724 543727 544019 547380 549086 549091 549098 552622 552921 555807 556521 562769 567082 568731 570721 572954 576445 576990 580735 584721 588190 593594 594272 594429 594503 595536 598433 600132 600805 601970 602802 603603 604371 605437 610965 629171 655281 658173 658555 662148 683303 683341 686576 715808 731978 740860 748192 750334 756269 758979 762980 765659 766076 767125 769848 774022 777410 780243 780650 787611 789838 790542 795490 795555 797204 800523 801916 802552 802952 804327 805536 807669 809121 810512 811632 813285 814237 814527 814959 815092 815132 818516 818518 818527 818544 821445 821553 821716 823092 823529 827858 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая teen пов"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small teen pov"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая teen пов"
]
|
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.