Query Metrics
7
Database Queries
7
Different statements
171.59 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.21 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.88 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young russian mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.80 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 478546 400479 439616 455218 463087 477725 511160 511517 512516 518835 526840 494842 508525 502730 520876 490430 494516 512717 515914 522056 533610 464542 631179 563218 470774 484684 451456 558003 539351 662423 390382 400845 439620 466141 439680 460734 466189 469030 471046 511595 513960 538234 491324 504651 498730 547932 439623 511023 512384 543579 557118 626024 474784 411344 439673 466271 534168 486110 490182 504908 650155 609140 470290 470596 482492 609085 421871 421907 439534 490944 508860 510108 584708 563441 599353 614479 620098 422270 639258 621489 751565 627380 484688 579205 472388 559950 533746 597240 ] |
||||||||||||||||||||||||||||||
| 4 | 3.35 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 390382 400479 400845 411344 421871 421907 422270 439534 439616 439620 439623 439673 439680 451456 455218 460734 463087 464542 466141 466189 466271 469030 470290 470596 470774 471046 472388 474784 477725 478546 482492 484684 484688 486110 490182 490430 490944 491324 494516 494842 498730 502730 504651 504908 508525 508860 510108 511023 511160 511517 511595 512384 512516 512717 513960 515914 518835 520876 522056 526840 533610 533746 534168 538234 539351 543579 547932 557118 558003 559950 563218 563441 579205 584708 597240 599353 609085 609140 614479 620098 621489 626024 627380 631179 639258 650155 662423 751565 ] |
||||||||||||||||||||||||||||||
| 5 | 140.28 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 390382 400479 400845 411344 421871 421907 422270 439534 439616 439620 439623 439673 439680 451456 455218 460734 463087 464542 466141 466189 466271 469030 470290 470596 470774 471046 472388 474784 477725 478546 482492 484684 484688 486110 490182 490430 490944 491324 494516 494842 498730 502730 504651 504908 508525 508860 510108 511023 511160 511517 511595 512384 512516 512717 513960 515914 518835 520876 522056 526840 533610 533746 534168 538234 539351 543579 547932 557118 558003 559950 563218 563441 579205 584708 597240 599353 609085 609140 614479 620098 621489 626024 627380 631179 639258 650155 662423 751565 ] |
||||||||||||||||||||||||||||||
| 6 | 2.05 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young русск mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.02 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young русск mom"
]
|
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.