Symfony Profiler

SELECT 
  shopware_ordernumber 
FROM 
  elio_configurator 
WHERE 
  active = 1 
  and id = : id

SELECT shopware_ordernumber FROM elio_configurator WHERE active  = 1 and id = '8193';

SELECT 
  * 
FROM 
  elio_configurator_save 
WHERE 
  status = : status 
  AND configuratorID = : id 
  AND userID = : userID

SELECT * FROM elio_configurator_save WHERE status = 1 AND configuratorID = '8193' AND userID = '1856';

SELECT 
  saved 
FROM 
  elio_configurator_save 
WHERE 
  id = : loadID

SELECT saved FROM elio_configurator_save WHERE id = '553184';

SELECT 
  saved, 
  saved_price, 
  price, 
  saved_price_old, 
  saved_cmp_prices, 
  blacklist 
FROM 
  elio_configurator_save 
WHERE 
  id = ?

SELECT saved,saved_price,price,saved_price_old,saved_cmp_prices,blacklist FROM elio_configurator_save WHERE id = '553184';

UPDATE 
  elio_configurator_save 
SET 
  saved_price_old = ? 
WHERE 
  id = ?

UPDATE elio_configurator_save SET saved_price_old = 0 WHERE id = '553184';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '2084';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='2084'
            OR
            c.id='8193'
            AND csubsc.componentID='2084';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '6631';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='6631'
            OR
            c.id='8193'
            AND csubsc.componentID='6631';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '3743';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='3743'
            OR
            c.id='8193'
            AND csubsc.componentID='3743';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '6482';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='6482'
            OR
            c.id='8193'
            AND csubsc.componentID='6482';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '6488';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='6488'
            OR
            c.id='8193'
            AND csubsc.componentID='6488';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '390';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='390'
            OR
            c.id='8193'
            AND csubsc.componentID='390';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '6633';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='6633'
            OR
            c.id='8193'
            AND csubsc.componentID='6633';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '4468';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='4468'
            OR
            c.id='8193'
            AND csubsc.componentID='4468';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '1';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '2627';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='2627'
            OR
            c.id='8193'
            AND csubsc.componentID='2627';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '5310';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='5310'
            OR
            c.id='8193'
            AND csubsc.componentID='5310';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '5310';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='5310'
            OR
            c.id='8193'
            AND csubsc.componentID='5310';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '391';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='391'
            OR
            c.id='8193'
            AND csubsc.componentID='391';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '1830';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='1830'
            OR
            c.id='8193'
            AND csubsc.componentID='1830';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '2026';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?

SELECT c.id as confid
            FROM elio_configurator c
            LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID=c.id
            LEFT JOIN elio_configurator_sets s ON s.id=chs.setID
            LEFT JOIN elio_configurator_sets_components csc ON csc.setID=s.id
            LEFT JOIN elio_configurator_components cc ON cc.id=csc.componentID
            LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID=cc.id
            LEFT JOIN elio_configurator_sets csubs ON csubs.id=cchs.setID
            LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID=csubs.id
            LEFT JOIN elio_configurator_components csubc ON csubc.id=csubsc.componentID
            WHERE c.id='8193'
            AND csc.componentID='2026'
            OR
            c.id='8193'
            AND csubsc.componentID='2026';

SELECT 
  categorie 
FROM 
  elio_configurator 
where 
  id = ?

SELECT categorie FROM elio_configurator where id = '8193';

SELECT 
  price 
FROM 
  elio_configurator_components_prices 
WHERE 
  categorie = ? 
  AND componentID = ?

SELECT price FROM elio_configurator_components_prices WHERE categorie = '3' AND componentID = '1931';

SELECT 
  saved_cmp_prices 
FROM 
  elio_configurator_save 
where 
  id = ?

SELECT saved_cmp_prices FROM elio_configurator_save where id = '553184';

SELECT 
  c.id as confid 
FROM 
  elio_configurator c 
  LEFT JOIN elio_configurator_has_sets chs ON chs.configuratorID = c.id 
  LEFT JOIN elio_configurator_sets s ON s.id = chs.setID 
  LEFT JOIN elio_configurator_sets_components csc ON csc.setID = s.id 
  LEFT JOIN elio_configurator_components cc ON cc.id = csc.componentID 
  LEFT JOIN elio_configurator_components_has_sets cchs ON cchs.componentID = cc.id 
  LEFT JOIN elio_configurator_sets csubs ON csubs.id = cchs.setID 
  LEFT JOIN elio_configurator_sets_components csubsc ON csubsc.setID = csubs.id 
  LEFT JOIN elio_configurator_components csubc ON csubc.id = csubsc.componentID 
WHERE 
  c.id = ? 
  AND csc.componentID = ? 
  OR c.id = ? 
  AND csubsc.componentID = ?