Query Metrics
7
Database Queries
7
Different statements
161.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.32 ms (85.82%) |
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 76645 188369 388350 391652 395427 404175 404386 404568 406561 408509 409506 411334 411704 411929 413904 415773 415779 421654 422338 428823 433769 439441 439484 439766 440399 440944 447969 448818 448820 450154 450226 450765 453265 454223 454240 455058 456200 457852 458728 460273 460583 463156 464267 464372 465535 466011 466211 466875 466877 466883 468123 468369 469347 469505 469575 470019 470043 470373 472656 474674 474685 475828 475904 476487 476907 477521 481673 483375 484681 485275 486549 487706 489947 489989 490484 491950 492992 495813 499329 507033 508603 511071 511348 513480 515511 519146 520881 520936 522364 523401 523777 526049 533198 536406 544617 546964 555054 555108 555126 555391 555435 557244 564176 565649 565887 579876 580319 583730 590929 606776 615525 618776 620223 631504 707318 725587 761018 765555 787287 800511 ] |
||||||||||||||||||||||||||||||
|
13.63 ms (8.46%) |
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 511348 580319 448818 468369 481673 523777 519146 765555 477521 555391 450765 447969 606776 555435 469505 453265 450154 460273 476487 415773 565887 448820 536406 590929 564176 464267 475904 508603 413904 469347 415779 486549 466011 495813 522364 469575 557244 546964 474674 485275 544617 458728 579876 404175 555108 422338 620223 618776 460583 520881 523401 499329 428823 492992 472656 555054 725587 555126 513480 484681 421654 515511 565649 463156 406561 631504 615525 409506 440944 533198 583730 707318 787287 761018 411929 439766 457852 76645 455058 466211 490484 440399 466883 188369 391652 411334 411704 464372 408509 439441 489989 468123 465535 388350 439484 507033 483375 404568 470019 466875 489947 454240 800511 395427 475828 511071 491950 526049 520936 433769 476907 470373 466877 474685 450226 470043 454223 487706 456200 404386 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.54%) |
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 76645 188369 388350 391652 395427 404175 404386 404568 406561 408509 409506 411334 411704 411929 413904 415773 415779 421654 422338 428823 433769 439441 439484 439766 440399 440944 447969 448818 448820 450154 450226 450765 453265 454223 454240 455058 456200 457852 458728 460273 460583 463156 464267 464372 465535 466011 466211 466875 466877 466883 468123 468369 469347 469505 469575 470019 470043 470373 472656 474674 474685 475828 475904 476487 476907 477521 481673 483375 484681 485275 486549 487706 489947 489989 490484 491950 492992 495813 499329 507033 508603 511071 511348 513480 515511 519146 520881 520936 522364 523401 523777 526049 533198 536406 544617 546964 555054 555108 555126 555391 555435 557244 564176 565649 565887 579876 580319 583730 590929 606776 615525 618776 620223 631504 707318 725587 761018 765555 787287 800511 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончают в пизду зрелкам"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм в вагин зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм в вагин зрелая женщин"
]
|
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.