Query Metrics
7
Database Queries
7
Different statements
175.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.35 ms (84.72%) |
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 399170 417940 419950 421609 425572 426499 432719 434252 442611 447911 447947 449400 450674 452308 452324 452594 452669 453832 455579 457884 459585 459727 460544 461366 461784 463021 466059 466557 469530 478126 483691 483867 486879 489023 489529 490513 492708 495140 495873 496244 498825 502586 503754 503768 505877 508419 510341 511548 512745 513326 513371 513838 515855 516850 517981 518391 520201 521365 522249 523013 523532 528006 528235 534174 534378 536865 542746 542784 545633 545747 551525 551886 552355 560783 562869 562938 564132 565283 571230 573273 580312 584635 585751 588078 588860 589710 594036 594644 594933 595043 595978 596573 596862 596882 597144 598846 599963 600344 600716 605762 605984 606225 607574 609731 612548 614680 618612 619730 624756 624875 625860 629330 631656 639908 646178 662594 728820 762234 800556 800808 ] |
||||||||||||||||||||||||||||||
|
17.14 ms (9.79%) |
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 562938 564132 594644 594933 596862 597144 600716 606225 639908 589710 595978 600344 614680 625860 618612 624756 800556 728820 762234 607574 629330 800808 417940 421609 432719 442611 453832 461366 455579 461784 399170 426499 452669 459585 478126 434252 449400 450674 452308 459727 463021 460544 518391 492708 511548 513371 515855 528235 483691 489529 490513 498825 512745 513326 516850 522249 523532 534174 483867 486879 496244 502586 505877 508419 513838 495140 469530 551525 542746 545747 585751 595043 624875 588078 596882 452594 452324 510341 517981 520201 457884 605762 609731 528006 560783 523013 419950 425572 466059 466557 447911 447947 503754 503768 534378 536865 495873 521365 489023 565283 571230 573273 542784 562869 580312 584635 545633 551886 552355 646178 662594 599963 605984 588860 598846 631656 612548 619730 594036 596573 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public cum mouth"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (1.31%) |
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 399170 417940 419950 421609 425572 426499 432719 434252 442611 447911 447947 449400 450674 452308 452324 452594 452669 453832 455579 457884 459585 459727 460544 461366 461784 463021 466059 466557 469530 478126 483691 483867 486879 489023 489529 490513 492708 495140 495873 496244 498825 502586 503754 503768 505877 508419 510341 511548 512745 513326 513371 513838 515855 516850 517981 518391 520201 521365 522249 523013 523532 528006 528235 534174 534378 536865 542746 542784 545633 545747 551525 551886 552355 560783 562869 562938 564132 565283 571230 573273 580312 584635 585751 588078 588860 589710 594036 594644 594933 595043 595978 596573 596862 596882 597144 598846 599963 600344 600716 605762 605984 606225 607574 609731 612548 614680 618612 619730 624756 624875 625860 629330 631656 639908 646178 662594 728820 762234 800556 800808 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на cum улиц mouth"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на cum улиц mouth"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.