Query Metrics
7
Database Queries
7
Different statements
190.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.52 ms (85.50%) |
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 359441 388175 391186 395242 415497 416146 417878 418564 418575 420143 423171 437302 440890 442444 447725 449907 451293 457354 459593 461445 465215 466299 471591 474737 475161 475352 482007 484061 485095 485636 489273 492230 495311 496743 500044 503193 503357 503763 506512 511988 520274 521092 521257 521764 521770 522296 523500 525412 526697 529142 539299 553937 554600 554614 567313 567562 569394 570825 580533 581922 585250 586019 586050 588132 590214 593985 594583 599490 601664 610672 610831 615673 621339 637203 637701 638688 641160 641464 641482 641485 641492 650687 660110 664097 678826 692750 696158 700966 701260 706912 708279 710259 713329 715768 717167 722227 726662 736905 736988 739855 742244 742348 756589 759325 764141 771251 778681 787114 789057 793368 793835 797375 803814 804860 804891 805141 807332 813071 821838 ] |
||||||||||||||||||||||||||||||
|
17.47 ms (9.19%) |
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 660110 599490 601664 593985 594583 590214 793368 742244 742348 803814 459593 395242 388175 418564 821838 451293 482007 495311 500044 526697 521257 511988 521764 521770 485095 569394 567562 678826 692750 706912 715768 570825 585250 641482 641464 641492 789057 805141 807332 726662 736988 764141 610831 641160 701260 797375 804860 417878 457354 466299 474737 437302 503193 522296 485636 521092 359441 391186 440890 465215 449907 529142 496743 503357 520274 503763 581922 696158 722227 664097 700966 708279 554614 580533 586050 615673 637701 638688 787114 793835 736905 771251 739855 756589 759325 610672 713329 778681 804891 813071 418575 461445 471591 447725 492230 523500 484061 489273 567313 650687 607290 637203 641485 506512 525412 420143 415497 423171 442444 416146 475161 539299 475352 554600 710259 717167 553937 586019 588132 621339 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.49%) |
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 359441 388175 391186 395242 415497 416146 417878 418564 418575 420143 423171 437302 440890 442444 447725 449907 451293 457354 459593 461445 465215 466299 471591 474737 475161 475352 482007 484061 485095 485636 489273 492230 495311 496743 500044 503193 503357 503763 506512 511988 520274 521092 521257 521764 521770 522296 523500 525412 526697 529142 539299 553937 554600 554614 567313 567562 569394 570825 580533 581922 585250 586019 586050 588132 590214 593985 594583 599490 601664 610672 610831 615673 621339 637203 637701 638688 641160 641464 641482 641485 641492 650687 660110 664097 678826 692750 696158 700966 701260 706912 708279 710259 713329 715768 717167 722227 726662 736905 736988 739855 742244 742348 756589 759325 764141 771251 778681 787114 789057 793368 793835 797375 803814 804860 804891 805141 807332 813071 821838 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex hotel"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hotel"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hotel"
]
|
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.