Query Metrics
7
Database Queries
7
Different statements
108.30 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.39 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.65 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature wife cuckold"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.88 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 823456 819767 760859 767804 795039 417328 517048 620754 623149 726248 518072 496794 534000 605461 605398 609610 472252 507102 588404 524018 803781 632413 511257 528081 516661 445740 607413 439649 455891 460486 490287 456788 466778 390288 549239 467571 567337 766623 571428 814062 460690 447038 699398 595731 459159 555969 448402 513269 513265 486583 605521 504158 514578 630915 511808 493260 439748 439583 443792 551553 414184 455974 585960 464834 590620 465933 545216 559682 496603 520127 651276 475630 426281 420307 425655 453841 515396 540792 414014 606759 614720 593860 504768 583723 ] |
||||||||||||||||||||||||||||||
| 4 | 2.10 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 390288 414014 414184 417328 420307 425655 426281 439583 439649 439748 443792 445740 447038 448402 453841 455891 455974 456788 459159 460486 460690 464834 465933 466778 467571 472252 475630 486583 490287 493260 496603 496794 504158 504768 507102 511257 511808 513265 513269 514578 515396 516661 517048 518072 520127 524018 528081 534000 540792 545216 549239 551553 555969 559682 567337 571428 583723 585960 588404 590620 593860 595731 605398 605461 605521 606759 607413 609610 614720 620754 623149 630915 632413 651276 699398 726248 760859 766623 767804 795039 803781 814062 819767 823456 ] |
||||||||||||||||||||||||||||||
| 5 | 86.37 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 390288 414014 414184 417328 420307 425655 426281 439583 439649 439748 443792 445740 447038 448402 453841 455891 455974 456788 459159 460486 460690 464834 465933 466778 467571 472252 475630 486583 490287 493260 496603 496794 504158 504768 507102 511257 511808 513265 513269 514578 515396 516661 517048 518072 520127 524018 528081 534000 540792 545216 549239 551553 555969 559682 567337 571428 583723 585960 588404 590620 593860 595731 605398 605461 605521 606759 607413 609610 614720 620754 623149 630915 632413 651276 699398 726248 760859 766623 767804 795039 803781 814062 819767 823456 ] |
||||||||||||||||||||||||||||||
| 6 | 1.49 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature жен куколд"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.42 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature жен куколд"
]
|
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.