Query Metrics
7
Database Queries
7
Different statements
194.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.97 ms (88.23%) |
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 88182 256949 386522 405448 418375 423639 427218 429930 430718 431652 434277 434936 443044 445431 452253 452397 454039 455675 457594 464118 464258 464639 466466 469148 476315 476320 477474 478518 479972 491222 492593 497324 508262 509303 510888 514447 515543 515875 520529 525149 527497 527534 528156 529396 529713 530333 530679 531520 532090 536695 537696 542192 544303 547347 549308 550720 554528 563538 563986 568136 569821 570804 571031 571817 579594 583163 587901 589365 590952 593146 593232 596033 598328 603109 606171 606732 607464 626324 629923 648503 648777 650375 653209 656206 656266 671092 684066 700743 706656 710769 719926 731626 735511 750982 752359 756433 756658 762332 770155 771349 774393 776398 782388 783939 788258 788263 788272 788590 789870 790810 792552 793520 798071 799802 803200 803203 811060 814438 819150 819237 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (7.10%) |
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 811060 783939 587901 431652 418375 520529 549308 735511 719926 478518 532090 492593 457594 793520 607464 593232 544303 700743 788590 491222 771349 571031 762332 386522 429930 814438 531520 537696 570804 788272 750982 756433 770155 788263 452397 547347 684066 648777 629923 626324 782388 434936 515875 756658 514447 464639 530333 530679 550720 710769 803200 455675 479972 466466 508262 731626 528156 579594 430718 706656 671092 593146 603109 497324 589365 405448 648503 650375 515543 510888 434277 423639 464258 789870 527534 88182 443044 819237 529396 568136 596033 606171 790810 774393 542192 469148 445431 476315 509303 536695 554528 477474 527497 525149 571817 563538 598328 803203 464118 656206 656266 788258 776398 792552 454039 590952 752359 583163 653209 799802 427218 563986 606732 798071 256949 819150 452253 529713 476320 569821 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.40%) |
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 88182 256949 386522 405448 418375 423639 427218 429930 430718 431652 434277 434936 443044 445431 452253 452397 454039 455675 457594 464118 464258 464639 466466 469148 476315 476320 477474 478518 479972 491222 492593 497324 508262 509303 510888 514447 515543 515875 520529 525149 527497 527534 528156 529396 529713 530333 530679 531520 532090 536695 537696 542192 544303 547347 549308 550720 554528 563538 563986 568136 569821 570804 571031 571817 579594 583163 587901 589365 590952 593146 593232 596033 598328 603109 606171 606732 607464 626324 629923 648503 648777 650375 653209 656206 656266 671092 684066 700743 706656 710769 719926 731626 735511 750982 752359 756433 756658 762332 770155 771349 774393 776398 782388 783939 788258 788263 788272 788590 789870 790810 792552 793520 798071 799802 803200 803203 811060 814438 819150 819237 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl compilation"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.72%) |
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.