Query Metrics
7
Database Queries
7
Different statements
146.05 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde milf solo"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.62 ms |
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 434076 454006 471074 473489 470061 447241 471077 527912 469457 483762 547779 547791 547944 548098 542987 547802 573194 669936 547757 547776 592778 602181 605858 460335 418817 183074 418069 454384 525355 489075 499917 528572 491777 527923 516718 321277 422803 458678 467568 475137 467585 468514 503670 515413 472190 572245 547800 598940 633485 88286 463832 426647 528318 496096 525204 514927 414271 452817 477506 542989 710161 546315 444527 455901 486831 496564 467939 797170 452937 456684 520797 517928 581873 662444 607027 477260 511946 605182 482308 483474 553832 389462 419628 477424 545300 ] |
||||||||||||||||||||||||||||||
| 4 | 1.97 ms |
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 88286 183074 321277 389462 414271 418069 418817 419628 422803 426647 434076 444527 447241 452817 452937 454006 454384 455901 456684 458678 460335 463832 467568 467585 467939 468514 469457 470061 471074 471077 472190 473489 475137 477260 477424 477506 482308 483474 483762 486831 489075 491777 496096 496564 499917 503670 511946 514927 515413 516718 517928 520797 525204 525355 527912 527923 528318 528572 542987 542989 545300 546315 547757 547776 547779 547791 547800 547802 547944 548098 553832 572245 573194 581873 592778 598940 602181 605182 605858 607027 633485 662444 669936 710161 797170 ] |
||||||||||||||||||||||||||||||
| 5 | 122.13 ms |
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 88286 183074 321277 389462 414271 418069 418817 419628 422803 426647 434076 444527 447241 452817 452937 454006 454384 455901 456684 458678 460335 463832 467568 467585 467939 468514 469457 470061 471074 471077 472190 473489 475137 477260 477424 477506 482308 483474 483762 486831 489075 491777 496096 496564 499917 503670 511946 514927 515413 516718 517928 520797 525204 525355 527912 527923 528318 528572 542987 542989 545300 546315 547757 547776 547779 547791 547800 547802 547944 548098 553832 572245 573194 581873 592778 598940 602181 605182 605858 607027 633485 662444 669936 710161 797170 ] |
||||||||||||||||||||||||||||||
| 6 | 1.39 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая milf соло"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая milf соло"
]
|
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.