Query Metrics
7
Database Queries
7
Different statements
182.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.53 ms (86.86%) |
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 5852 76268 149261 184909 185208 185456 185714 185820 185873 322773 357753 357824 357943 367863 382357 382650 382696 383181 387835 389304 390178 390224 390318 390321 390329 390731 390908 399008 406993 407494 408150 408841 413195 422233 447570 461644 464616 551430 554340 565943 578424 578437 590747 592545 600613 603516 606809 607286 618937 624269 628339 628340 636798 648491 651928 651941 652177 652855 653241 653246 653308 654154 654331 654385 662038 662978 663391 672457 672518 676929 681411 687138 690148 707360 716127 720458 722810 722896 724712 726467 727394 728411 735417 735530 735684 738907 738960 740007 740485 741290 741812 742993 745451 746473 747372 747376 747383 772394 772484 776798 779532 785417 785419 785776 792833 793624 797705 797706 802686 806226 810789 811675 813478 813951 815622 816038 816564 817702 817734 818047 ] |
||||||||||||||||||||||||||||||
|
13.91 ms (7.62%) |
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 590747 387835 390321 382696 672518 76268 406993 722810 690148 806226 738907 747383 390908 185873 681411 654331 606809 811675 727394 740007 740485 747372 722896 735417 653241 408150 654154 676929 185714 815622 461644 390178 687138 792833 779532 785776 185820 651941 648491 707360 607286 592545 776798 797705 802686 726467 738960 724712 357753 818047 816564 716127 628340 793624 772394 746473 741812 785417 797706 422233 407494 184909 652855 382357 662978 185456 813951 628339 408841 447570 817702 390731 399008 578437 636798 357943 383181 817734 747376 785419 367863 5852 816038 565943 672457 720458 663391 603516 600613 813478 741290 735530 149261 185208 389304 390329 653246 390224 413195 578424 651928 652177 653308 618937 810789 772484 322773 390318 382650 357824 654385 662038 728411 745451 735684 742993 464616 624269 551430 554340 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.44%) |
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 5852 76268 149261 184909 185208 185456 185714 185820 185873 322773 357753 357824 357943 367863 382357 382650 382696 383181 387835 389304 390178 390224 390318 390321 390329 390731 390908 399008 406993 407494 408150 408841 413195 422233 447570 461644 464616 551430 554340 565943 578424 578437 590747 592545 600613 603516 606809 607286 618937 624269 628339 628340 636798 648491 651928 651941 652177 652855 653241 653246 653308 654154 654331 654385 662038 662978 663391 672457 672518 676929 681411 687138 690148 707360 716127 720458 722810 722896 724712 726467 727394 728411 735417 735530 735684 738907 738960 740007 740485 741290 741812 742993 745451 746473 747372 747376 747383 772394 772484 776798 779532 785417 785419 785776 792833 793624 797705 797706 802686 806226 810789 811675 813478 813951 815622 816038 816564 817702 817734 818047 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex massage"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс массаж"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.