Query Metrics
7
Database Queries
7
Different statements
147.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.45 ms (83.08%) |
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 358942 382091 383483 383595 386557 387328 393431 395513 395750 397023 397662 397855 400408 401194 402092 404600 407365 410324 411787 420276 421201 421328 423463 423480 423946 424811 426777 428867 430313 431080 432529 436636 436645 437737 437875 440292 444986 448774 449438 449881 450326 450597 453716 454409 456916 457418 458812 459124 459708 460739 464955 469287 474151 474415 475278 475378 477337 478940 479803 483001 485813 486145 490456 492039 493127 494148 494202 499786 501896 505460 506436 507193 508485 512658 515964 516222 519073 520895 525095 525116 527329 527415 527767 534288 539462 545926 551290 551547 555933 555993 557972 558647 565716 568349 569897 569935 571839 590889 591306 595507 595854 596423 599160 600489 601644 619520 619920 620044 620319 628045 628046 683766 726528 726550 730486 741190 776638 800926 807529 813917 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (11.04%) |
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 527767 493127 596423 383595 813917 464955 515964 478940 555933 545926 620319 595854 601644 807529 741190 619520 776638 426777 477337 450326 437875 453716 527329 490456 499786 430313 620044 599160 600489 628045 423946 395513 454409 479803 539462 555993 557972 726550 404600 424811 402092 387328 410324 397662 423480 421328 525095 519073 507193 494148 628046 411787 460739 421201 420276 474415 516222 565716 571839 590889 726528 475378 506436 494202 395750 393431 595507 456916 397855 431080 527415 483001 568349 591306 508485 407365 400408 382091 436645 486145 525116 505460 469287 457418 383483 440292 569935 459124 449881 534288 619920 730486 432529 475278 397023 401194 512658 428867 449438 501896 551547 558647 569897 492039 386557 436636 450597 683766 485813 474151 358942 520895 444986 423463 437737 448774 458812 459708 551290 800926 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.47%) |
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 358942 382091 383483 383595 386557 387328 393431 395513 395750 397023 397662 397855 400408 401194 402092 404600 407365 410324 411787 420276 421201 421328 423463 423480 423946 424811 426777 428867 430313 431080 432529 436636 436645 437737 437875 440292 444986 448774 449438 449881 450326 450597 453716 454409 456916 457418 458812 459124 459708 460739 464955 469287 474151 474415 475278 475378 477337 478940 479803 483001 485813 486145 490456 492039 493127 494148 494202 499786 501896 505460 506436 507193 508485 512658 515964 516222 519073 520895 525095 525116 527329 527415 527767 534288 539462 545926 551290 551547 555933 555993 557972 558647 565716 568349 569897 569935 571839 590889 591306 595507 595854 596423 599160 600489 601644 619520 619920 620044 620319 628045 628046 683766 726528 726550 730486 741190 776638 800926 807529 813917 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boy massage"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"парен массаж"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен массаж"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.01%) |
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.