Query Metrics
7
Database Queries
7
Different statements
176.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.79 ms (83.36%) |
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 45799 188335 365865 390508 391917 391992 397167 416121 417332 417789 419319 420300 421795 424118 424124 424547 424765 427260 428610 432438 440755 442070 444145 444185 446947 450287 452810 453323 453334 453547 453571 453578 453719 454456 454461 454958 456030 457587 458768 460368 461902 462707 463152 467016 472403 472673 473376 473384 479107 479261 481167 481747 483361 484181 485386 491860 492005 493177 496512 498441 500976 505833 510334 511631 515617 518975 519751 520114 524803 524991 525717 529166 531566 533583 533953 536430 541850 543404 544109 549689 549727 549737 557605 558755 561506 562469 565632 566361 567211 573196 575339 578829 581013 582262 590666 591928 595097 595270 595288 595328 607576 618668 623412 625275 630142 638380 650664 662879 664241 668807 690882 712828 724481 726550 733044 733579 735855 741687 748383 758803 ] |
||||||||||||||||||||||||||||||
|
18.76 ms (10.66%) |
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 607576 630142 421795 424118 462707 467016 479261 452810 472403 440755 454461 473376 424124 481747 510334 520114 484181 519751 496512 524991 536430 453571 549737 575339 595328 595097 733579 735855 188335 454958 543404 544109 573196 690882 566361 590666 625275 456030 533583 733044 365865 578829 638380 500976 391917 397167 428610 432438 442070 417789 420300 424547 424765 450287 453323 453719 461902 473384 491860 492005 453334 505833 531566 524803 518975 529166 460368 549689 549727 558755 561506 565632 581013 582262 541850 557605 650664 664241 668807 562469 595270 595288 591928 618668 758803 741687 724481 726550 748383 623412 472673 479107 391992 453578 457587 481167 417332 444145 416121 485386 498441 525717 483361 493177 515617 444185 427260 533953 511631 567211 463152 446947 454456 45799 390508 712828 662879 419319 453547 458768 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.76%) |
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 45799 188335 365865 390508 391917 391992 397167 416121 417332 417789 419319 420300 421795 424118 424124 424547 424765 427260 428610 432438 440755 442070 444145 444185 446947 450287 452810 453323 453334 453547 453571 453578 453719 454456 454461 454958 456030 457587 458768 460368 461902 462707 463152 467016 472403 472673 473376 473384 479107 479261 481167 481747 483361 484181 485386 491860 492005 493177 496512 498441 500976 505833 510334 511631 515617 518975 519751 520114 524803 524991 525717 529166 531566 533583 533953 536430 541850 543404 544109 549689 549727 549737 557605 558755 561506 562469 565632 566361 567211 573196 575339 578829 581013 582262 590666 591928 595097 595270 595288 595328 607576 618668 623412 625275 630142 638380 650664 662879 664241 668807 690882 712828 724481 726550 733044 733579 735855 741687 748383 758803 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby жен riding"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby wife riding"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby жен riding"
]
|
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.