Query Metrics
7
Database Queries
7
Different statements
163.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.07 ms (86.52%) |
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 399853 400426 401120 403496 413228 416185 417428 418421 418484 418493 429105 443729 451596 463873 463954 465128 466161 466987 472179 494692 506445 519725 529152 530632 537767 541879 543720 544471 545717 546200 551431 552127 558033 558601 560184 561833 563874 563876 564000 565265 566807 569674 569692 571468 574606 574870 575737 575786 581687 597494 597518 598471 598553 598745 600105 604425 604467 605335 620300 622623 624231 624273 624830 627724 627804 628363 634187 647343 656575 668377 671626 680182 681813 683341 684541 687541 696219 696978 701009 703101 714432 714448 714473 715228 720484 720800 720825 721325 722781 722897 723492 725112 726292 731693 739074 742422 744303 746155 747956 753943 760586 761076 762702 766432 766990 767060 767510 768120 775962 776878 788800 805347 810701 811669 811863 814069 814554 818390 819510 827610 ] |
||||||||||||||||||||||||||||||
|
13.32 ms (8.17%) |
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 627724 597494 805347 746155 753943 624231 703101 714432 714448 722781 788800 811863 451596 418493 575786 571468 401120 413228 544471 564000 681813 687541 604425 624273 726292 417428 541879 569692 575737 627804 569674 604467 624830 400426 466987 472179 463873 466161 494692 819510 529152 537767 563876 683341 701009 715228 696978 720484 600105 776878 731693 739074 747956 761076 762702 767510 744303 767060 768120 760586 558601 634187 766432 622623 818390 545717 399853 443729 530632 543720 671626 696219 574870 597518 598471 605335 620300 810701 775962 811669 725112 742422 721325 416185 519725 647343 680182 546200 598745 628363 574606 598553 418484 465128 418421 463954 506445 403496 566807 766990 722897 723492 429105 814554 827610 814069 551431 561833 552127 558033 565265 581687 656575 684541 720800 668377 714473 720825 560184 563874 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.58%) |
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 399853 400426 401120 403496 413228 416185 417428 418421 418484 418493 429105 443729 451596 463873 463954 465128 466161 466987 472179 494692 506445 519725 529152 530632 537767 541879 543720 544471 545717 546200 551431 552127 558033 558601 560184 561833 563874 563876 564000 565265 566807 569674 569692 571468 574606 574870 575737 575786 581687 597494 597518 598471 598553 598745 600105 604425 604467 605335 620300 622623 624231 624273 624830 627724 627804 628363 634187 647343 656575 668377 671626 680182 681813 683341 684541 687541 696219 696978 701009 703101 714432 714448 714473 715228 720484 720800 720825 721325 722781 722897 723492 725112 726292 731693 739074 742422 744303 746155 747956 753943 760586 761076 762702 766432 766990 767060 767510 768120 775962 776878 788800 805347 810701 811669 811863 814069 814554 818390 819510 827610 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young small teen"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young маленькая teen"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young маленькая teen"
]
|
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.