Query Metrics
7
Database Queries
7
Different statements
147.59 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.65 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.30 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sharing cock"
]
|
||||||||||||||||||||||||||||||
| 3 | 20.56 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 576356 582459 580771 663172 550302 572214 632021 469118 477373 498205 510572 490035 604700 510157 187953 428479 423568 814923 814738 466493 472496 452418 472783 515956 554783 543392 561892 569689 587251 630915 808757 621508 635490 458182 492921 495231 502921 516635 518730 496650 488822 438765 385377 437686 437814 467025 502554 531278 502453 517440 524235 463625 486759 542056 678556 583302 636579 628654 620612 478546 410603 514659 503807 519346 545501 443660 492688 537944 502540 682303 401916 466994 478108 584703 615909 521852 560215 521495 497865 490068 560783 622228 651937 529290 584688 549246 567148 477230 ] |
||||||||||||||||||||||||||||||
| 4 | 2.48 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 187953 385377 401916 410603 423568 428479 437686 437814 438765 443660 452418 458182 463625 466493 466994 467025 469118 472496 472783 477230 477373 478108 478546 486759 488822 490035 490068 492688 492921 495231 496650 497865 498205 502453 502540 502554 502921 503807 510157 510572 514659 515956 516635 517440 518730 519346 521495 521852 524235 529290 531278 537944 542056 543392 545501 549246 550302 554783 560215 560783 561892 567148 569689 572214 576356 580771 582459 583302 584688 584703 587251 604700 615909 620612 621508 622228 628654 630915 632021 635490 636579 651937 663172 678556 682303 808757 814738 814923 ] |
||||||||||||||||||||||||||||||
| 5 | 117.62 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 187953 385377 401916 410603 423568 428479 437686 437814 438765 443660 452418 458182 463625 466493 466994 467025 469118 472496 472783 477230 477373 478108 478546 486759 488822 490035 490068 492688 492921 495231 496650 497865 498205 502453 502540 502554 502921 503807 510157 510572 514659 515956 516635 517440 518730 519346 521495 521852 524235 529290 531278 537944 542056 543392 545501 549246 550302 554783 560215 560783 561892 567148 569689 572214 576356 580771 582459 583302 584688 584703 587251 604700 615909 620612 621508 622228 628654 630915 632021 635490 636579 651937 663172 678556 682303 808757 814738 814923 ] |
||||||||||||||||||||||||||||||
| 6 | 1.56 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"sharing cock"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.42 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"sharing 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.