Query Metrics
7
Database Queries
7
Different statements
141.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.61 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.95 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"naked pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.21 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 410642 430314 435226 470254 476752 418361 442946 449428 472319 411201 521535 520766 485786 492760 509033 499817 501338 426025 418941 437810 431112 450510 475439 476098 476706 447930 477890 514820 521526 541748 565740 579301 630771 404876 421353 410051 411445 471629 462949 463808 476913 514307 516078 522221 504908 513338 512927 420291 523280 592521 609085 603523 467581 508860 417801 477210 504841 560193 598657 595795 590884 621273 624095 624779 620754 412593 468078 510433 497917 513940 567156 659328 557537 561304 598806 466404 501497 521740 486400 514809 591647 475630 491023 519933 560230 613487 ] |
||||||||||||||||||||||||||||||
| 4 | 2.80 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 404876 410051 410642 411201 411445 412593 417801 418361 418941 420291 421353 426025 430314 431112 435226 437810 442946 447930 449428 450510 462949 463808 466404 467581 468078 470254 471629 472319 475439 475630 476098 476706 476752 476913 477210 477890 485786 486400 491023 492760 497917 499817 501338 501497 504841 504908 508860 509033 510433 512927 513338 513940 514307 514809 514820 516078 519933 520766 521526 521535 521740 522221 523280 541748 557537 560193 560230 561304 565740 567156 579301 590884 591647 592521 595795 598657 598806 603523 609085 613487 620754 621273 624095 624779 630771 659328 ] |
||||||||||||||||||||||||||||||
| 5 | 113.94 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 404876 410051 410642 411201 411445 412593 417801 418361 418941 420291 421353 426025 430314 431112 435226 437810 442946 447930 449428 450510 462949 463808 466404 467581 468078 470254 471629 472319 475439 475630 476098 476706 476752 476913 477210 477890 485786 486400 491023 492760 497917 499817 501338 501497 504841 504908 508860 509033 510433 512927 513338 513940 514307 514809 514820 516078 519933 520766 521526 521535 521740 522221 523280 541748 557537 560193 560230 561304 565740 567156 579301 590884 591647 592521 595795 598657 598806 603523 609085 613487 620754 621273 624095 624779 630771 659328 ] |
||||||||||||||||||||||||||||||
| 6 | 2.05 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"голые pussy"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.41 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"голые pussy"
]
|
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.