Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "thai girl"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'thai girl' LIMIT 1;

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  591440
  616080
  577767
  568625
  600535
  594400
  709117
  599829
  810176
  772507
  639783
  460030
  493852
  555532
  568618
  712276
  568621
  588577
  813109
  734146
  447426
  587307
  744711
  668451
  615983
  473300
  546865
  756279
  698109
  399230
  568631
  709961
  556371
  606709
  568629
  580053
  583851
  559782
  690682
  591748
  619125
  568614
  708263
  789067
  626432
  522263
  491195
  547089
  568617
  648937
  477399
  538223
  568638
  721557
  626876
  514199
  602575
  600610
  813110
  701206
  571812
  500594
  420680
  557361
  647162
  621353
  432990
  550882
  458437
  527756
  500600
  808467
  496887
  460327
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (591440, 616080, 577767, 568625, 600535, 594400, 709117, 599829, 810176, 772507, 639783, 460030, 493852, 555532, 568618, 712276, 568621, 588577, 813109, 734146, 447426, 587307, 744711, 668451, 615983, 473300, 546865, 756279, 698109, 399230, 568631, 709961, 556371, 606709, 568629, 580053, 583851, 559782, 690682, 591748, 619125, 568614, 708263, 789067, 626432, 522263, 491195, 547089, 568617, 648937, 477399, 538223, 568638, 721557, 626876, 514199, 602575, 600610, 813110, 701206, 571812, 500594, 420680, 557361, 647162, 621353, 432990, 550882, 458437, 527756, 500600, 808467, 496887, 460327);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  399230
  420680
  432990
  447426
  458437
  460030
  460327
  473300
  477399
  491195
  493852
  496887
  500594
  500600
  514199
  522263
  527756
  538223
  546865
  547089
  550882
  555532
  556371
  557361
  559782
  568614
  568617
  568618
  568621
  568625
  568629
  568631
  568638
  571812
  577767
  580053
  583851
  587307
  588577
  591440
  591748
  594400
  599829
  600535
  600610
  602575
  606709
  615983
  616080
  619125
  621353
  626432
  626876
  639783
  647162
  648937
  668451
  690682
  698109
  701206
  708263
  709117
  709961
  712276
  721557
  734146
  744711
  756279
  772507
  789067
  808467
  810176
  813109
  813110
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (399230, 420680, 432990, 447426, 458437, 460030, 460327, 473300, 477399, 491195, 493852, 496887, 500594, 500600, 514199, 522263, 527756, 538223, 546865, 547089, 550882, 555532, 556371, 557361, 559782, 568614, 568617, 568618, 568621, 568625, 568629, 568631, 568638, 571812, 577767, 580053, 583851, 587307, 588577, 591440, 591748, 594400, 599829, 600535, 600610, 602575, 606709, 615983, 616080, 619125, 621353, 626432, 626876, 639783, 647162, 648937, 668451, 690682, 698109, 701206, 708263, 709117, 709961, 712276, 721557, 734146, 744711, 756279, 772507, 789067, 808467, 810176, 813109, 813110);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  399230
  420680
  432990
  447426
  458437
  460030
  460327
  473300
  477399
  491195
  493852
  496887
  500594
  500600
  514199
  522263
  527756
  538223
  546865
  547089
  550882
  555532
  556371
  557361
  559782
  568614
  568617
  568618
  568621
  568625
  568629
  568631
  568638
  571812
  577767
  580053
  583851
  587307
  588577
  591440
  591748
  594400
  599829
  600535
  600610
  602575
  606709
  615983
  616080
  619125
  621353
  626432
  626876
  639783
  647162
  648937
  668451
  690682
  698109
  701206
  708263
  709117
  709961
  712276
  721557
  734146
  744711
  756279
  772507
  789067
  808467
  810176
  813109
  813110
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (399230, 420680, 432990, 447426, 458437, 460030, 460327, 473300, 477399, 491195, 493852, 496887, 500594, 500600, 514199, 522263, 527756, 538223, 546865, 547089, 550882, 555532, 556371, 557361, 559782, 568614, 568617, 568618, 568621, 568625, 568629, 568631, 568638, 571812, 577767, 580053, 583851, 587307, 588577, 591440, 591748, 594400, 599829, 600535, 600610, 602575, 606709, 615983, 616080, 619125, 621353, 626432, 626876, 639783, 647162, 648937, 668451, 690682, 698109, 701206, 708263, 709117, 709961, 712276, 721557, 734146, 744711, 756279, 772507, 789067, 808467, 810176, 813109, 813110);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "тайк азиатк девушк"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'тайк азиатк девушк';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "тайк азиатк девушк"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'тайк азиатк девушк';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "thai girl"
  "thai girl"
  "thai girl"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('thai girl') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('thai girl')
              AND `query` <> 'thai girl'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;