Query Metrics
7
Database Queries
7
Different statements
180.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.81 ms (83.35%) |
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 387101 393081 395274 397456 411693 417542 418938 421376 425401 430285 437323 441996 443862 448177 450192 451509 453006 453838 454477 455587 456507 457380 459353 459541 459564 459798 460437 460894 463948 466034 470119 471819 472449 472452 473045 475471 478669 480737 482305 483121 483340 484755 487131 491455 491654 491671 493337 493434 497058 505846 505961 506036 507802 508977 509085 510037 512255 513278 514384 514710 517491 520490 546140 547075 552640 554366 568422 571066 572918 574874 579825 579837 579867 579868 579873 582665 585910 587679 588023 593620 593622 593750 593758 593767 593775 593776 595967 603464 604679 607780 613238 617161 630497 632734 641547 668451 672342 672367 682226 693967 699577 718438 718894 726470 742046 747654 748979 751704 761320 761580 769924 770838 770929 777168 785007 786462 808525 818630 820881 823420 ] |
||||||||||||||||||||||||||||||
|
20.31 ms (11.23%) |
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 770838 425401 397456 823420 450192 454477 472452 480737 457380 470119 508977 517491 579868 552640 582665 579837 593758 630497 641547 777168 430285 393081 514710 483121 512255 491455 387101 418938 547075 571066 574874 672367 668451 579873 593620 593776 585910 587679 593750 593767 808525 769924 785007 726470 460894 411693 484755 491671 579825 632734 441996 421376 818630 718438 682226 588023 595967 603464 607780 593775 613238 770929 786462 742046 748979 761320 761580 747654 751704 604679 455587 453838 459564 478669 572918 493337 456507 506036 546140 693967 510037 505846 395274 417542 459798 718894 672342 473045 471819 448177 459541 507802 483340 493434 459353 463948 451509 460437 475471 472449 497058 699577 554366 579867 593622 617161 466034 453006 443862 482305 491654 513278 509085 514384 487131 505961 520490 437323 820881 568422 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.27%) |
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 387101 393081 395274 397456 411693 417542 418938 421376 425401 430285 437323 441996 443862 448177 450192 451509 453006 453838 454477 455587 456507 457380 459353 459541 459564 459798 460437 460894 463948 466034 470119 471819 472449 472452 473045 475471 478669 480737 482305 483121 483340 484755 487131 491455 491654 491671 493337 493434 497058 505846 505961 506036 507802 508977 509085 510037 512255 513278 514384 514710 517491 520490 546140 547075 552640 554366 568422 571066 572918 574874 579825 579837 579867 579868 579873 582665 585910 587679 588023 593620 593622 593750 593758 593767 593775 593776 595967 603464 604679 607780 613238 617161 630497 632734 641547 668451 672342 672367 682226 693967 699577 718438 718894 726470 742046 747654 748979 751704 761320 761580 769924 770838 770929 777168 785007 786462 808525 818630 820881 823420 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"surprise dick"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"surprise член"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"surprise член"
]
|
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.