Query Metrics
7
Database Queries
7
Different statements
331.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.71 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.09 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stop sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.27 ms |
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 493280 418901 464043 454419 568909 565174 597967 629398 424516 466814 482228 580238 624375 446601 506677 521545 465531 544067 580750 807580 724921 457667 469745 435934 434003 485236 505792 524749 580620 515811 537209 679799 565412 645016 671676 572031 632975 442910 445443 459661 476882 427292 430374 434364 489866 451264 528402 538530 500912 524320 574773 614431 415818 516721 519522 604046 456074 545440 537919 628390 733840 733870 530269 421489 554854 608772 596880 434369 489262 459710 533944 537914 628398 510571 654671 576859 552306 449150 652197 551539 614609 520778 575445 642044 610574 611289 625215 525525 501119 619003 ] |
||||||||||||||||||||||||||||||
| 4 | 211.57 ms |
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 415818 418901 421489 424516 427292 430374 434003 434364 434369 435934 442910 445443 446601 449150 451264 454419 456074 457667 459661 459710 464043 465531 466814 469745 476882 482228 485236 489262 489866 493280 500912 501119 505792 506677 510571 515811 516721 519522 520778 521545 524320 524749 525525 528402 530269 533944 537209 537914 537919 538530 544067 545440 551539 552306 554854 565174 565412 568909 572031 574773 575445 576859 580238 580620 580750 596880 597967 604046 608772 610574 611289 614431 614609 619003 624375 625215 628390 628398 629398 632975 642044 645016 652197 654671 671676 679799 724921 733840 733870 ] |
||||||||||||||||||||||||||||||
| 5 | 96.81 ms |
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 415818 418901 421489 424516 427292 430374 434003 434364 434369 435934 442910 445443 446601 449150 451264 454419 456074 457667 459661 459710 464043 465531 466814 469745 476882 482228 485236 489262 489866 493280 500912 501119 505792 506677 510571 515811 516721 519522 520778 521545 524320 524749 525525 528402 530269 533944 537209 537914 537919 538530 544067 545440 551539 552306 554854 565174 565412 568909 572031 574773 575445 576859 580238 580620 580750 596880 597967 604046 608772 610574 611289 614431 614609 619003 624375 625215 628390 628398 629398 632975 642044 645016 652197 654671 671676 679799 724921 733840 733870 ] |
||||||||||||||||||||||||||||||
| 6 | 1.63 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stop секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.35 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stop секс"
]
|
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.