Query Metrics
7
Database Queries
7
Different statements
143.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.66 ms (82.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 36832 58847 381776 382017 382661 384880 385042 386060 390967 391302 392807 392903 393429 393706 393728 393751 393765 394184 394198 396522 399511 400441 400443 400458 400463 400471 403210 429234 456656 464280 464317 467169 469874 470855 472248 472912 481154 488003 492205 492595 494352 494356 494362 505497 515120 515135 515198 515215 515219 519973 522443 534126 542934 545528 545529 556969 564154 566505 569427 569661 569664 569685 569784 570051 570056 570059 570068 590250 593440 593847 595863 604467 609929 620801 663411 664842 665399 667323 676510 676942 678803 684254 684572 684582 684590 684594 684596 686776 694537 700945 701007 701016 708802 708804 709578 714432 716563 719129 720480 731982 732116 732145 734613 743122 743123 744309 744329 747568 747840 747852 747855 747861 747875 759649 765442 765445 765446 767959 816661 824513 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (10.51%) |
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 569784 665399 382017 734613 381776 765445 765446 400463 678803 744329 765442 731982 570059 456656 393429 593847 743122 393751 716563 684594 732145 382661 816661 667323 676942 590250 515219 566505 400441 824513 481154 400471 570051 569685 429234 747852 556969 569427 663411 747568 545529 732116 58847 494362 403210 392807 494356 393728 400458 385042 519973 545528 570056 708804 743123 747875 747840 747861 701007 386060 467169 492205 664842 609929 393765 396522 515120 469874 676510 767959 391302 470855 542934 492595 684596 701016 709578 700945 593440 393706 394198 384880 515215 522443 390967 515135 719129 36832 595863 569664 564154 684572 747855 400443 464317 394184 570068 488003 392903 694537 399511 604467 464280 472912 684254 720480 620801 515198 569661 714432 494352 505497 684590 472248 684582 759649 744309 708802 534126 686776 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.65%) |
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 36832 58847 381776 382017 382661 384880 385042 386060 390967 391302 392807 392903 393429 393706 393728 393751 393765 394184 394198 396522 399511 400441 400443 400458 400463 400471 403210 429234 456656 464280 464317 467169 469874 470855 472248 472912 481154 488003 492205 492595 494352 494356 494362 505497 515120 515135 515198 515215 515219 519973 522443 534126 542934 545528 545529 556969 564154 566505 569427 569661 569664 569685 569784 570051 570056 570059 570068 590250 593440 593847 595863 604467 609929 620801 663411 664842 665399 667323 676510 676942 678803 684254 684572 684582 684590 684594 684596 686776 694537 700945 701007 701016 708802 708804 709578 714432 716563 719129 720480 731982 732116 732145 734613 743122 743123 744309 744329 747568 747840 747852 747855 747861 747875 759649 765442 765445 765446 767959 816661 824513 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
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.