Query Metrics
7
Database Queries
7
Different statements
164.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.17 ms (83.79%) |
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 383773 384813 384880 386207 386354 386653 388838 390772 392393 393726 393727 393737 393749 395221 396473 396757 400425 400435 400443 400450 400455 400461 400463 400471 400903 402090 403210 413208 415906 418645 419027 443967 445040 446254 456656 464277 464315 467296 470707 470844 470855 473239 489619 491193 491490 495024 512047 515091 515279 515294 519064 523172 537845 550440 550601 554307 566511 566515 569685 569686 570050 570051 570069 578461 578464 585997 586634 587929 590224 597264 597574 598537 598683 598777 603160 607173 607193 607742 618882 618962 624850 644654 644697 646208 654963 655861 663473 663482 664828 665475 667316 667543 668857 676951 682515 689603 691993 696973 704547 714452 716236 716450 722651 722706 722912 732116 732466 733048 737673 740854 743082 743131 744291 744324 748158 756097 759599 775781 813905 820225 ] |
||||||||||||||||||||||||||||||
|
15.24 ms (9.24%) |
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 644654 722651 445040 386653 400903 392393 395221 396473 396757 523172 569686 654963 603160 470844 570050 820225 464277 598537 740854 400463 515091 515279 519064 495024 393727 388838 443967 813905 665475 682515 689603 716450 667316 716236 664828 704547 618962 624850 732466 733048 743082 759599 744291 732116 744324 748158 737673 756097 775781 400450 393726 393737 515294 383773 400425 400443 400455 403210 491490 512047 569685 578461 676951 663473 668857 714452 566511 587929 597264 598683 597574 618882 743131 644697 446254 473239 418645 393749 470707 491193 384813 537845 646208 386207 386354 384880 390772 400435 400461 400471 402090 415906 419027 413208 489619 456656 464315 467296 470855 554307 570051 578464 550601 570069 550440 655861 667543 663482 691993 696973 722912 722706 566515 598777 607742 585997 586634 607193 590224 607173 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.28%) |
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 383773 384813 384880 386207 386354 386653 388838 390772 392393 393726 393727 393737 393749 395221 396473 396757 400425 400435 400443 400450 400455 400461 400463 400471 400903 402090 403210 413208 415906 418645 419027 443967 445040 446254 456656 464277 464315 467296 470707 470844 470855 473239 489619 491193 491490 495024 512047 515091 515279 515294 519064 523172 537845 550440 550601 554307 566511 566515 569685 569686 570050 570051 570069 578461 578464 585997 586634 587929 590224 597264 597574 598537 598683 598777 603160 607173 607193 607742 618882 618962 624850 644654 644697 646208 654963 655861 663473 663482 664828 665475 667316 667543 668857 676951 682515 689603 691993 696973 704547 714452 716236 716450 722651 722706 722912 732116 732466 733048 737673 740854 743082 743131 744291 744324 748158 756097 759599 775781 813905 820225 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl and old"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк old"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк old"
]
|
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.