Query Metrics
7
Database Queries
7
Different statements
208.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
184.48 ms (88.51%) |
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 384789 394187 400454 402245 411717 412289 453097 460332 463168 464299 469336 474162 474876 476248 480420 483135 486110 492392 494352 495160 505497 506213 512047 514692 515123 515140 515189 515195 515197 515231 520300 522056 523265 524312 545521 550441 554134 562312 565107 565703 566046 566517 567150 569661 569677 570071 578464 586631 593440 596543 598962 618906 620757 663368 663404 663437 663439 663473 663925 663940 663965 665140 665215 665229 665284 665288 665317 665379 665448 665457 665850 665875 666123 666809 667196 667209 667474 667498 667532 667563 667859 667878 676492 676930 679826 691993 692859 699772 700945 709578 714432 714447 732387 733175 736022 743082 743371 744312 744328 748252 756097 758198 762472 763629 771336 771342 774479 777345 778419 788212 788582 795594 810572 813905 814620 819382 826900 827188 827523 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (6.82%) |
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 469336 515195 565107 545521 550441 596543 483135 676492 819382 762472 412289 578464 569661 663473 777345 788212 732387 714432 494352 505497 524312 679826 570071 460332 464299 480420 515197 566046 618906 520300 515189 522056 620757 411717 665140 827188 453097 400454 463168 691993 814620 813905 495160 565703 663940 665229 665850 666123 666809 667209 676930 709578 665215 663404 663439 663925 700945 566517 593440 598962 810572 736022 743082 756097 778419 795594 474876 771342 476248 515123 474162 586631 515140 567150 663368 667563 743371 562312 667498 665379 744328 486110 774479 515231 492392 523265 506213 714447 827523 665288 665457 665284 744312 569677 554134 699772 733175 763629 771336 394187 402245 663437 692859 514692 512047 665317 665448 667474 667878 667196 667859 663965 665875 667532 788582 748252 758198 384789 764586 826900 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.30%) |
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 384789 394187 400454 402245 411717 412289 453097 460332 463168 464299 469336 474162 474876 476248 480420 483135 486110 492392 494352 495160 505497 506213 512047 514692 515123 515140 515189 515195 515197 515231 520300 522056 523265 524312 545521 550441 554134 562312 565107 565703 566046 566517 567150 569661 569677 570071 578464 586631 593440 596543 598962 618906 620757 663368 663404 663437 663439 663473 663925 663940 663965 665140 665215 665229 665284 665288 665317 665379 665448 665457 665850 665875 666123 666809 667196 667209 667474 667498 667532 667563 667859 667878 676492 676930 679826 691993 692859 699772 700945 709578 714432 714447 732387 733175 736022 743082 743371 744312 744328 748252 756097 758198 762472 763629 771336 771342 774479 777345 778419 788212 788582 795594 810572 813905 814620 819382 826900 827188 827523 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс old"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob old"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.72%) |
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.