Symfony Profiler

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1);

SELECT
  DISTINCT(c.idcontact),
  c.organisation,
  c.country,
  c.city,
  c.url_clean
FROM
  contacts c
WHERE
  1
  AND c.idcontact IN (
    SELECT
      DISTINCT(texts.idcontact_publisher)
    FROM
      texts
    WHERE
      texts.publish = 1
  )
  AND c.organisation REGEXP '^D'
ORDER BY
  c.organisation

SELECT DISTINCT(c.idcontact), c.organisation, c.country, c.city, c.url_clean FROM contacts c WHERE 1
            AND c.idcontact IN
                (SELECT DISTINCT(texts.idcontact_publisher) FROM texts WHERE texts.publish=1) AND c.organisation REGEXP '^D'  ORDER BY c.organisation;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2510

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2510;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CH'

SELECT fr FROM countries WHERE id='CH';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 23095

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=23095;

SELECT
  fr
FROM
  countries
WHERE
  id = 'US'

SELECT fr FROM countries WHERE id='US';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 17349

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=17349;

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 28810

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=28810;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 6463

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=6463;

SELECT
  fr
FROM
  countries
WHERE
  id = 'GB'

SELECT fr FROM countries WHERE id='GB';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 13486

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=13486;

SELECT
  fr
FROM
  countries
WHERE
  id = 'NL'

SELECT fr FROM countries WHERE id='NL';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 10960

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=10960;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 22765

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=22765;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3422

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3422;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 11833

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=11833;

SELECT
  fr
FROM
  countries
WHERE
  id = 'IT'

SELECT fr FROM countries WHERE id='IT';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1734

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1734;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3173

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3173;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1784

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1784;

SELECT
  fr
FROM
  countries
WHERE
  id = 'NO'

SELECT fr FROM countries WHERE id='NO';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3221

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3221;

SELECT
  fr
FROM
  countries
WHERE
  id = 'DE'

SELECT fr FROM countries WHERE id='DE';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1508

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1508;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 4630

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=4630;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1502

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1502;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 4228

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=4228;

SELECT
  fr
FROM
  countries
WHERE
  id = 'SK'

SELECT fr FROM countries WHERE id='SK';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 4621

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=4621;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2720

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2720;

SELECT
  fr
FROM
  countries
WHERE
  id = 'PT'

SELECT fr FROM countries WHERE id='PT';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1749

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1749;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 32692

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=32692;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2013

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2013;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 29294

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=29294;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 5426

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=5426;

SELECT
  fr
FROM
  countries
WHERE
  id = 'DK'

SELECT fr FROM countries WHERE id='DK';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 27022

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=27022;

SELECT
  fr
FROM
  countries
WHERE
  id = 'MX'

SELECT fr FROM countries WHERE id='MX';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 3796

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=3796;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 2241

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=2241;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1796

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1796;

SELECT
  fr
FROM
  countries
WHERE
  id = 'CA'

SELECT fr FROM countries WHERE id='CA';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1739

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1739;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 29135

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=29135;

SELECT
  fr
FROM
  countries
WHERE
  id = 'PL'

SELECT fr FROM countries WHERE id='PL';

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 163

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=163;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 20466

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=20466;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 29533

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=29533;

SELECT
  COUNT(
    DISTINCT(idtext)
  ) as total
FROM
  texts
WHERE
  idcontact_publisher = 1860

SELECT COUNT(DISTINCT(idtext)) as total
                FROM texts
                WHERE idcontact_publisher=1860;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_bottom = 1
  AND date_start <= NOW()
  AND date_end >= NOW()
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10;