Query Metrics
7
Database Queries
7
Different statements
161.03 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.72 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.16 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"yoga girl"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.84 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 416817 427845 483039 512121 520261 402105 404304 444620 456606 464082 459002 472241 512876 509654 516439 509379 469575 568077 556594 559222 549723 668807 635920 437996 500067 529204 472243 481362 541345 459016 458222 515567 463597 463368 484791 529306 552955 600466 463694 463544 463561 535448 498033 419138 435505 815108 479798 500506 520980 525773 489098 555140 471608 459908 453402 601650 520800 517752 558625 659407 635188 522105 531120 435225 454788 464857 507710 640755 422098 518248 510194 418361 519087 577931 463587 529212 503967 383616 307940 599694 430071 499594 515802 490373 596168 679076 529213 556489 561936 602945 ] |
||||||||||||||||||||||||||||||
| 4 | 4.42 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 307940 383616 402105 404304 416817 418361 419138 422098 427845 430071 435225 435505 437996 444620 453402 454788 456606 458222 459002 459016 459908 463368 463544 463561 463587 463597 463694 464082 464857 469575 471608 472241 472243 479798 481362 483039 484791 489098 490373 498033 499594 500067 500506 503967 507710 509379 509654 510194 512121 512876 515567 515802 516439 517752 518248 519087 520261 520800 520980 522105 525773 529204 529212 529213 529306 531120 535448 549723 552955 555140 556489 556594 558625 559222 561936 568077 577931 596168 599694 600466 601650 602945 635188 635920 640755 659407 668807 679076 815108 ] |
||||||||||||||||||||||||||||||
| 5 | 132.35 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 307940 383616 402105 404304 416817 418361 419138 422098 427845 430071 435225 435505 437996 444620 453402 454788 456606 458222 459002 459016 459908 463368 463544 463561 463587 463597 463694 464082 464857 469575 471608 472241 472243 479798 481362 483039 484791 489098 490373 498033 499594 500067 500506 503967 507710 509379 509654 510194 512121 512876 515567 515802 516439 517752 518248 519087 520261 520800 520980 522105 525773 529204 529212 529213 529306 531120 535448 549723 552955 555140 556489 556594 558625 559222 561936 568077 577931 596168 599694 600466 601650 602945 635188 635920 640755 659407 668807 679076 815108 ] |
||||||||||||||||||||||||||||||
| 6 | 1.89 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"yoga девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.65 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"yoga девушк"
]
|
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.