DEBUG: /i.html PAGE LOADED

URL Parameters:

Full URL: /baby/i.html?cur=9®ion=asia
GET: Array
(
    [cur] => 9
    [region] => asia
)
GPC: Array
(
    [cur] => 9
    [region] => asia
    [cid] => 49
    [mode] => product
    [sort] => 01
    [page] => 1
    [bidrange] => 
    [radiuszip] => 
    [list] => grid
)

Search Filters:

fields:             p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.crypto_currentprice, p.currentprice, p.project_id, p.cid, p.description, p.date_starts, p.date_added,
timestamp:          AND UNIX_TIMESTAMP(p.date_end) > UNIX_TIMESTAMP('2025-12-09 08:06:34')
projectstatus:      AND p.status = 'open'
categories:         AND (FIND_IN_SET(p.cid, '49,655,656,657,658,659,660,661,662,663,50,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,51,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,52,3648,3649,3650,3651,28927,3652,3653,53,3654,3655,3656,3657,3658,3659,3660,3661,3662,3663,3664,3665,3666,54,3667,3668,
options:            AND (FIND_IN_SET(p.currencyid, '9')) 
pricerange:         AND (p.currentprice >= 0 OR p.buynow_price >= 0)
location:           AND (FIND_IN_SET(p.countryid, '501,185,186,310,311,319,325,506,337,508,510,342,215,372,375,376,377,196,380,384,385,199,531,532,388,200,220,390,395,398,399,223,113,122,123,129,132,148,153,157,163,164,211,166,170,212,174,232,234,180,560,561,564')) 
groupby:            GROUP BY p.project_id
orderby:            ORDER BY p.date_starts DESC 
limit:              LIMIT 0,12
from:               FROM ilance_projects AS p
condition:          1=1
leftjoin:           LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_profiles pp ON (su.user_id = pp.user_id)
INNER JOIN ilance_projects_shipping s ON (p.project_id = s.proj
join_root_leftcat:  LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_profiles pp ON (p.user_id = pp.user_id)
LEFT JOIN ilance_projects_shipping s ON (p.project_id = s.projec
join_child_leftcat: LEFT JOIN ilance_projects p ON (node.cid = p.cid)
LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_profiles pp ON (su.user_id = pp.user_id)
INNER JOIN il
join_condition:     AND u.status = 'active' AND su.active = 'yes' AND ((p.lotid > 0 AND p.eventid > 0 AND e.published = '1') OR (p.eventid <= 0)) AND p.visible = '1' AND p.password = '' AND p.isfrozensub = '0' AND pp.mode = 'product' AND p.status != 'frozen' AND (p.enhancementfee = 0 OR (p.enhancementfee > 0 AND p.enha
final:              SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.crypto_currentprice, p.currentprice, p.project_id, p.cid, p.description, p.date_starts, p.date
final_nolimit:      SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.crypto_currentprice, p.currentprice, p.project_id, p.cid, p.description, p.date_starts, p.date
orderby_featured:   ORDER BY p.date_end ASC
orderby_recent:     ORDER BY p.date_added DESC
select:             SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.crypto_currentprice, p.currentprice, p.project_id, p.cid, p.description, p.date_starts, p.date
select_nolimit:     SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.crypto_currentprice, p.currentprice, p.project_id, p.cid, p.description, p.date_starts, p.date

DEBUG: Test Query Results

Test query finds: 1 products

DEBUG: Search SQL Filters

fields:             p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.c
timestamp:          AND UNIX_TIMESTAMP(p.date_end) > UNIX_TIMESTAMP('2025-12-09 08:06:34')
projectstatus:      AND p.status = 'open'
categories:         AND (FIND_IN_SET(p.cid, '49,655,656,657,658,659,660,661,662,663,50,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,51,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,52,3648,3649,3650,36
options:            AND (FIND_IN_SET(p.currencyid, '9')) 
pricerange:         AND (p.currentprice >= 0 OR p.buynow_price >= 0)
location:           AND (FIND_IN_SET(p.countryid, '501,185,186,310,311,319,325,506,337,508,510,342,215,372,375,376,377,196,380,384,385,199,531,532,388,200,220,390,395,398,399,223,113,122,123,129,132,148,153,157,163,164,2
groupby:            GROUP BY p.project_id
orderby:            ORDER BY p.date_starts DESC 
limit:              LIMIT 0,12
from:               FROM ilance_projects AS p
condition:          1=1
leftjoin:           LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_prof
join_root_leftcat:  LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_prof
join_child_leftcat: LEFT JOIN ilance_projects p ON (node.cid = p.cid)
LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.u
join_condition:     AND u.status = 'active' AND su.active = 'yes' AND ((p.lotid > 0 AND p.eventid > 0 AND e.published = '1') OR (p.eventid <= 0)) AND p.visible = '1' AND p.password = '' AND p.isfrozensub = '0' AND pp.mod
final:              SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
final_nolimit:      SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
orderby_featured:   ORDER BY p.date_end ASC
orderby_recent:     ORDER BY p.date_added DESC
select:             SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
select_nolimit:     SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas