Query Metrics
7
Database Queries
7
Different statements
158.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.14 ms (84.49%) |
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 384757 392422 393145 397655 407398 414070 414116 415857 416009 416680 417980 418139 418144 419352 420768 421820 425940 429598 429699 429737 429844 429889 430369 443099 443234 443920 444851 446026 446745 446785 447178 447191 448057 449022 450088 451266 451651 452798 452812 452833 452843 452880 453996 455793 456240 458829 460016 460168 462681 466404 468241 468269 468642 469463 470092 475752 478030 486779 495170 495470 496776 497675 498963 500335 500789 502468 502777 504509 505325 508882 511127 513183 513672 516807 519313 523578 526257 532778 534553 534612 538703 541212 545508 560925 564383 565308 569050 581174 582277 583698 587085 589073 593292 595209 595488 597750 598797 598932 604229 604423 606365 616296 621765 631593 632569 633485 637537 639119 651841 656913 656925 673833 684658 705809 742338 752589 804715 805144 814467 814492 ] |
||||||||||||||||||||||||||||||
|
15.09 ms (9.50%) |
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 516807 496776 444851 452798 468642 414070 429844 452843 470092 478030 446785 532778 656913 595209 416680 451266 416009 453996 456240 500335 495470 497675 511127 407398 814492 462681 606365 742338 752589 495170 631593 466404 447178 443099 560925 582277 446745 425940 418139 460016 468241 450088 534553 538703 498963 502777 505325 523578 526257 534612 475752 545508 569050 583698 581174 541212 684658 651841 598932 604423 621765 639119 589073 604229 595488 633485 443234 415857 429598 429699 429737 469463 458829 504509 565308 597750 429889 421820 632569 417980 447191 508882 443920 393145 392422 397655 814467 448057 452812 460168 673833 705809 587085 598797 616296 804715 452880 519313 656925 455793 384757 420768 486779 446026 452833 513183 805144 414116 418144 451651 430369 468269 449022 500789 419352 513672 564383 502468 637537 593292 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.64%) |
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 384757 392422 393145 397655 407398 414070 414116 415857 416009 416680 417980 418139 418144 419352 420768 421820 425940 429598 429699 429737 429844 429889 430369 443099 443234 443920 444851 446026 446745 446785 447178 447191 448057 449022 450088 451266 451651 452798 452812 452833 452843 452880 453996 455793 456240 458829 460016 460168 462681 466404 468241 468269 468642 469463 470092 475752 478030 486779 495170 495470 496776 497675 498963 500335 500789 502468 502777 504509 505325 508882 511127 513183 513672 516807 519313 523578 526257 532778 534553 534612 538703 541212 545508 560925 564383 565308 569050 581174 582277 583698 587085 589073 593292 595209 595488 597750 598797 598932 604229 604423 606365 616296 621765 631593 632569 633485 637537 639119 651841 656913 656925 673833 684658 705809 742338 752589 804715 805144 814467 814492 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац анус дилд"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мастурбирует очко дилдо"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац анус дилд"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
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.