Query Metrics
7
Database Queries
7
Different statements
122.15 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.82 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.06 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fat cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.55 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 526213 530110 530836 525501 530041 535882 461416 476349 492389 543503 566634 583724 553958 687006 666095 556771 569409 602811 606017 621647 595252 724176 644674 805638 457000 458974 466875 447750 451248 500896 486340 484316 411227 413791 445047 486408 486815 521367 498352 532701 535464 517722 522783 526214 473205 546042 550647 624843 603605 643370 447888 455436 430301 477716 527038 483357 459512 477721 484807 444438 452626 455685 466007 514576 501714 526254 569132 650083 623641 411189 515986 581096 603612 482808 518012 520413 607413 526587 493122 553300 597975 522616 561936 616994 ] |
||||||||||||||||||||||||||||||
| 4 | 2.47 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 411189 411227 413791 430301 444438 445047 447750 447888 451248 452626 455436 455685 457000 458974 459512 461416 466007 466875 473205 476349 477716 477721 482808 483357 484316 484807 486340 486408 486815 492389 493122 498352 500896 501714 514576 515986 517722 518012 520413 521367 522616 522783 525501 526213 526214 526254 526587 527038 530041 530110 530836 532701 535464 535882 543503 546042 550647 553300 553958 556771 561936 566634 569132 569409 581096 583724 595252 597975 602811 603605 603612 606017 607413 616994 621647 623641 624843 643370 644674 650083 666095 687006 724176 805638 ] |
||||||||||||||||||||||||||||||
| 5 | 100.14 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 411189 411227 413791 430301 444438 445047 447750 447888 451248 452626 455436 455685 457000 458974 459512 461416 466007 466875 473205 476349 477716 477721 482808 483357 484316 484807 486340 486408 486815 492389 493122 498352 500896 501714 514576 515986 517722 518012 520413 521367 522616 522783 525501 526213 526214 526254 526587 527038 530041 530110 530836 532701 535464 535882 543503 546042 550647 553300 553958 556771 561936 566634 569132 569409 581096 583724 595252 597975 602811 603605 603612 606017 607413 616994 621647 623641 624843 643370 644674 650083 666095 687006 724176 805638 ] |
||||||||||||||||||||||||||||||
| 6 | 1.50 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fat cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.61 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fat cock"
]
|
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.