Query Metrics
7
Database Queries
7
Different statements
206.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.55 ms (86.95%) |
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 52083 364620 381884 382845 395862 397079 403151 425738 429200 430298 451453 451613 454346 457265 457393 459554 460395 461002 461301 461772 462575 467174 467280 469207 470218 472798 475106 479996 482682 483132 488712 488926 490815 491674 495620 507426 512277 519665 522803 522821 525660 527334 529063 529067 534024 551174 551175 551193 552633 552646 562226 562236 562240 562298 562308 562318 562328 565432 569862 569881 569911 570194 570198 570251 570290 570310 570319 570336 570359 570361 570432 570469 570506 570540 570588 570593 570617 571541 571555 571557 571559 571614 571876 571928 572074 572091 572092 572103 572137 572141 572152 572153 572363 572482 572502 572505 572803 573023 573051 573078 573583 573617 573656 573811 589731 589785 589799 589805 594784 665435 671116 671146 696486 708671 721411 759463 766253 788166 811732 818729 ] |
||||||||||||||||||||||||||||||
|
15.62 ms (7.57%) |
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 552633 562298 562318 562328 570336 570361 571555 572103 572137 573051 788166 425738 451613 462575 469207 472798 52083 461301 461772 395862 397079 403151 451453 479996 364620 459554 475106 454346 488712 490815 495620 512277 522803 527334 522821 525660 507426 529063 529067 721411 572505 811732 589731 457265 491674 519665 818729 534024 708671 665435 671146 696486 759463 766253 382845 381884 429200 430298 482682 461002 457393 488926 470218 460395 467174 467280 483132 551174 552646 562308 565432 570319 570469 570588 572363 572803 551175 551193 569862 569881 570198 570290 570506 570593 571541 571557 571559 573617 562236 562240 569911 570194 570359 572074 572141 572152 572502 573078 671116 562226 570251 570310 570432 570540 570617 571614 571876 571928 572091 572092 572153 572482 573023 573583 573656 573811 589805 589785 589799 594784 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (1.94%) |
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 52083 364620 381884 382845 395862 397079 403151 425738 429200 430298 451453 451613 454346 457265 457393 459554 460395 461002 461301 461772 462575 467174 467280 469207 470218 472798 475106 479996 482682 483132 488712 488926 490815 491674 495620 507426 512277 519665 522803 522821 525660 527334 529063 529067 534024 551174 551175 551193 552633 552646 562226 562236 562240 562298 562308 562318 562328 565432 569862 569881 569911 570194 570198 570251 570290 570310 570319 570336 570359 570361 570432 570469 570506 570540 570588 570593 570617 571541 571555 571557 571559 571614 571876 571928 572074 572091 572092 572103 572137 572141 572152 572153 572363 572482 572502 572505 572803 573023 573051 573078 573583 573617 573656 573811 589731 589785 589799 589805 594784 665435 671116 671146 696486 708671 721411 759463 766253 788166 811732 818729 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ххх пикап"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ххх пикап"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.79%) |
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.