Query Metrics
7
Database Queries
7
Different statements
176.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.22 ms (86.26%) |
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 4290 9981 30208 33821 34049 56810 117869 163096 186171 192551 197587 200708 230762 275948 297917 337704 338116 359456 381790 382172 383171 384509 386065 386472 386587 386605 387213 388121 388559 390166 390720 390949 391767 391906 392055 392097 393122 394281 396331 396791 396967 397424 397601 397688 398749 398801 398881 400671 401858 410235 411812 412677 413209 416112 417154 427019 427429 427573 430958 432871 433045 433594 438486 445245 445331 453277 453552 454760 454764 455109 456067 459109 460075 460118 460133 461294 464068 467787 467841 469364 470033 471333 475878 477793 483322 483747 485862 486423 489549 503023 503377 505171 508223 510922 517678 524058 529132 541930 544302 546719 550172 551684 556040 558107 559433 571837 584645 592162 601186 641498 661380 710465 715488 752871 777011 797144 804781 806984 819337 821111 ] |
||||||||||||||||||||||||||||||
|
14.18 ms (8.03%) |
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 390949 411812 433045 454764 529132 571837 550172 551684 558107 715488 710465 592162 601186 804781 467841 192551 297917 337704 391906 396791 397688 430958 460133 186171 413209 412677 464068 394281 398881 821111 541930 359456 470033 275948 197587 471333 556040 416112 386587 382172 559433 454760 117869 392097 30208 445245 400671 401858 427019 517678 483322 386472 383171 230762 33821 34049 4290 398801 398749 417154 432871 453552 510922 461294 584645 544302 661380 546719 806984 56810 433594 9981 438486 477793 386065 397601 459109 200708 388121 388559 386605 396967 503377 396331 508223 163096 393122 392055 338116 390720 397424 427573 410235 445331 819337 469364 483747 453277 456067 485862 503023 505171 460075 489549 641498 777011 797144 752871 391767 427429 475878 460118 467787 486423 524058 390166 381790 384509 387213 455109 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.71%) |
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 4290 9981 30208 33821 34049 56810 117869 163096 186171 192551 197587 200708 230762 275948 297917 337704 338116 359456 381790 382172 383171 384509 386065 386472 386587 386605 387213 388121 388559 390166 390720 390949 391767 391906 392055 392097 393122 394281 396331 396791 396967 397424 397601 397688 398749 398801 398881 400671 401858 410235 411812 412677 413209 416112 417154 427019 427429 427573 430958 432871 433045 433594 438486 445245 445331 453277 453552 454760 454764 455109 456067 459109 460075 460118 460133 461294 464068 467787 467841 469364 470033 471333 475878 477793 483322 483747 485862 486423 489549 503023 503377 505171 508223 510922 517678 524058 529132 541930 544302 546719 550172 551684 556040 558107 559433 571837 584645 592162 601186 641498 661380 710465 715488 752871 777011 797144 804781 806984 819337 821111 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bra 1990"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бюстгалтер нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
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.