Query Metrics
7
Database Queries
7
Different statements
157.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.14 ms (86.94%) |
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 395676 402232 424214 425452 425804 431604 441280 446937 458470 458937 459486 459541 461651 463385 464647 465707 470359 474364 488736 490312 498377 500202 504989 506873 507013 511296 511347 512951 519325 520491 522249 525452 526372 526620 526984 531656 532179 533506 538384 538406 538998 540953 542902 543061 544781 546311 547726 551245 551909 560408 560786 562067 563352 569887 569906 570037 570239 570356 570463 571518 571576 571855 571890 573097 573662 573840 575315 576645 580335 582332 584945 593275 595654 599879 600193 602592 606578 609413 611609 620217 624201 628997 630172 631620 633468 644020 663240 663241 668398 668845 672769 675122 675128 675132 675146 675424 675438 676576 684518 687107 693679 702546 702908 706069 716962 729171 731092 740423 745493 759530 773185 781354 783758 789492 791005 805969 810981 818426 824757 ] |
||||||||||||||||||||||||||||||
|
12.20 ms (7.73%) |
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 431604 441280 818426 465707 810981 459541 506873 538998 458937 463385 526984 512951 511296 518967 620217 446937 525452 522249 551245 425452 425804 562067 540953 520491 488736 500202 461651 542902 582332 470359 507013 546311 672769 458470 531656 551909 395676 580335 584945 593275 745493 606578 402232 633468 459486 519325 424214 511347 504989 576645 560408 668398 609413 526372 600193 543061 560786 474364 716962 668845 702546 533506 791005 544781 628997 573662 789492 729171 824757 569906 740423 773185 702908 759530 570037 490312 532179 498377 676576 644020 573097 570356 706069 675146 783758 684518 805969 569887 575315 675132 663240 663241 731092 570463 631620 571576 547726 675424 571518 573840 595654 538406 693679 687107 675122 599879 571890 570239 781354 538384 624201 563352 464647 675128 675438 526620 571855 602592 611609 630172 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.61%) |
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 395676 402232 424214 425452 425804 431604 441280 446937 458470 458937 459486 459541 461651 463385 464647 465707 470359 474364 488736 490312 498377 500202 504989 506873 507013 511296 511347 512951 519325 520491 522249 525452 526372 526620 526984 531656 532179 533506 538384 538406 538998 540953 542902 543061 544781 546311 547726 551245 551909 560408 560786 562067 563352 569887 569906 570037 570239 570356 570463 571518 571576 571855 571890 573097 573662 573840 575315 576645 580335 582332 584945 593275 595654 599879 600193 602592 606578 609413 611609 620217 624201 628997 630172 631620 633468 644020 663240 663241 668398 668845 672769 675122 675128 675132 675146 675424 675438 676576 684518 687107 693679 702546 702908 706069 716962 729171 731092 740423 745493 759530 773185 781354 783758 789492 791005 805969 810981 818426 824757 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"it sexy girl"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sexy девушк"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sexy девушк"
]
|
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.