Query Metrics
7
Database Queries
7
Different statements
164.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.73 ms (83.00%) |
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 13229 74434 146508 152157 181009 187843 187851 188064 188338 191330 213330 213429 232973 233135 233321 233391 326115 366011 377323 382419 384268 384340 385314 385632 386991 387433 390923 391492 391520 391704 391705 397023 398545 398933 398938 400819 401960 404587 405491 408354 409324 409877 409932 409935 410732 411914 412273 412827 415544 417796 418971 419543 424439 427433 428475 428539 443154 443777 446630 453062 470965 474465 474794 474846 517589 520892 532051 532062 534221 537548 542957 557514 561453 562013 562961 563053 563433 565146 570909 594767 605460 623145 630068 640892 663466 663861 666970 674556 702455 702904 702978 710593 714504 717683 720121 725570 734309 740826 744321 746621 748231 753707 765299 766663 770494 774314 781696 788277 788868 789537 804112 805199 805266 805685 807452 808438 811923 813924 823686 824014 ] |
||||||||||||||||||||||||||||||
|
18.42 ms (11.18%) |
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 377323 233135 443154 187843 409932 748231 424439 474846 517589 663466 605460 720121 443777 537548 382419 823686 824014 534221 570909 702904 717683 702455 563433 565146 623145 630068 805266 804112 805199 766663 774314 702978 714504 805685 74434 391705 391492 191330 562961 789537 807452 746621 811923 232973 13229 384268 405491 408354 813924 532051 562013 666970 710593 663861 674556 594767 808438 734309 744321 753707 781696 386991 397023 213429 213330 419543 385632 233321 385314 152157 188064 326115 404587 409877 428539 411914 412273 427433 474794 474465 446630 532062 542957 557514 561453 770494 788868 740826 725570 765299 788277 188338 398933 391704 400819 409935 470965 384340 181009 401960 410732 428475 520892 146508 387433 398938 409324 233391 366011 391520 412827 415544 417796 418971 187851 398545 563053 640892 390923 453062 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.42%) |
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 13229 74434 146508 152157 181009 187843 187851 188064 188338 191330 213330 213429 232973 233135 233321 233391 326115 366011 377323 382419 384268 384340 385314 385632 386991 387433 390923 391492 391520 391704 391705 397023 398545 398933 398938 400819 401960 404587 405491 408354 409324 409877 409932 409935 410732 411914 412273 412827 415544 417796 418971 419543 424439 427433 428475 428539 443154 443777 446630 453062 470965 474465 474794 474846 517589 520892 532051 532062 534221 537548 542957 557514 561453 562013 562961 563053 563433 565146 570909 594767 605460 623145 630068 640892 663466 663861 666970 674556 702455 702904 702978 710593 714504 717683 720121 725570 734309 740826 744321 746621 748231 753707 765299 766663 770494 774314 781696 788277 788868 789537 804112 805199 805266 805685 807452 808438 811923 813924 823686 824014 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother old"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин old"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин old"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.97%) |
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.