Query Metrics
7
Database Queries
7
Different statements
123.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.65 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.90 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"a young daughter"
]
|
||||||||||||||||||||||||||||||
| 3 | 25.75 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 518927 550230 565050 591585 623818 524281 675006 623616 603878 447089 520008 384524 407362 418922 434624 412132 433852 448687 566257 728452 400196 409682 433669 430833 430839 473980 469909 431242 491999 494731 483392 522207 434055 412297 418953 430190 477346 523405 460282 401933 400249 412289 431350 442946 430846 431376 519038 404742 412288 452178 456915 482555 495198 529212 519632 486540 564826 599659 395666 482350 425523 494345 519931 486198 489082 444003 477079 514824 502995 491978 550571 421907 491963 486594 429409 458719 460673 518960 474035 466963 424780 420635 517008 484519 534645 485313 517000 560511 499882 ] |
||||||||||||||||||||||||||||||
| 4 | 2.23 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 384524 395666 400196 400249 401933 404742 407362 409682 412132 412288 412289 412297 418922 418953 420635 421907 424780 425523 429409 430190 430833 430839 430846 431242 431350 431376 433669 433852 434055 434624 442946 444003 447089 448687 452178 456915 458719 460282 460673 466963 469909 473980 474035 477079 477346 482350 482555 483392 484519 485313 486198 486540 486594 489082 491963 491978 491999 494345 494731 495198 499882 502995 514824 517000 517008 518927 518960 519038 519632 519931 520008 522207 523405 524281 529212 534645 550230 550571 560511 564826 565050 566257 591585 599659 603878 623616 623818 675006 728452 ] |
||||||||||||||||||||||||||||||
| 5 | 88.56 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 384524 395666 400196 400249 401933 404742 407362 409682 412132 412288 412289 412297 418922 418953 420635 421907 424780 425523 429409 430190 430833 430839 430846 431242 431350 431376 433669 433852 434055 434624 442946 444003 447089 448687 452178 456915 458719 460282 460673 466963 469909 473980 474035 477079 477346 482350 482555 483392 484519 485313 486198 486540 486594 489082 491963 491978 491999 494345 494731 495198 499882 502995 514824 517000 517008 518927 518960 519038 519632 519931 520008 522207 523405 524281 529212 534645 550230 550571 560511 564826 565050 566257 591585 599659 603878 623616 623818 675006 728452 ] |
||||||||||||||||||||||||||||||
| 6 | 1.91 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young daughter"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.41 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young daughter"
]
|
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.