SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002148s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002013s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002019s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000279s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 621 LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 621 [ RunTime:0.000366s ]
SELECT `id`,`name` FROM `product_type` WHERE `typeid` = 49 [ RunTime:0.000174s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001108s ]
SELECT `s`.`id`,`s`.*,`u`.`company`,`t`.`name` FROM `stock` `s` LEFT JOIN `user` `u` ON `u`.`id`=`s`.`userid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( ( `status` = 1 OR `status` = 3 OR `status` = 4 OR ( `status` = 2 AND `expiretime` > '2025-09-28 06:05:30' ) ) AND `categoryid` = 621 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,10 [ RunTime:0.012117s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10080 LIMIT 4 [ RunTime:0.000371s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10080 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10080 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10080 LIMIT 2 [ RunTime:0.000260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10080 ORDER BY `minOrder` ASC [ RunTime:0.000157s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '760390014' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.010094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 923 LIMIT 4 [ RunTime:0.000175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 923 ORDER BY `minOrder` ASC [ RunTime:0.000147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 923 ORDER BY `unit` DESC [ RunTime:0.000146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 923 LIMIT 2 [ RunTime:0.000143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 923 ORDER BY `minOrder` ASC [ RunTime:0.000142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OEP8000' OR `brand` LIKE 'OEP (OXFORD ELECTRICAL PRODUCTS)%' ) ) LIMIT 1 [ RunTime:0.000158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 705 LIMIT 4 [ RunTime:0.000219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 705 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 705 ORDER BY `unit` DESC [ RunTime:0.000236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 705 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 705 ORDER BY `minOrder` ASC [ RunTime:0.000151s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FL2/12' OR `brand` LIKE 'BLOCK%' ) ) LIMIT 1 [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15218 LIMIT 4 [ RunTime:0.000149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.000145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15218 ORDER BY `unit` DESC [ RunTime:0.000143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15218 LIMIT 2 [ RunTime:0.000143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15218 ORDER BY `minOrder` ASC [ RunTime:0.000142s ]
select * from pdf where partno='OEP8000' and brandshort='OEP OXFORD ELECTRICAL PRODUCTS' limit 1 [ RunTime:0.000323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OEP8000' OR `brand` LIKE 'OEP (OXFORD ELECTRICAL PRODUCTS)%' ) ) LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15113 LIMIT 4 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15113 ORDER BY `minOrder` ASC [ RunTime:0.000240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15113 ORDER BY `unit` DESC [ RunTime:0.000232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15113 LIMIT 2 [ RunTime:0.000241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15113 ORDER BY `minOrder` ASC [ RunTime:0.000229s ]
select * from pdf where partno='OEP8000' and brandshort='OEP OXFORD ELECTRICAL PRODUCTS' limit 1 [ RunTime:0.000303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'OEP8000' OR `brand` LIKE 'OEP (OXFORD ELECTRICAL PRODUCTS)%' ) ) LIMIT 1 [ RunTime:0.000233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12595 LIMIT 4 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12595 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12595 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12595 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12595 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HHM1732B1' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.009112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 704 LIMIT 4 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 704 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 704 ORDER BY `unit` DESC [ RunTime:0.000395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 704 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 704 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P3356' OR `brand` LIKE 'ETAL%' ) ) LIMIT 1 [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3384 LIMIT 4 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3384 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3384 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3384 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3384 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='VTX-110-006' and brandshort='VIGORTRONIX' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VTX-110-006' OR `brand` LIKE 'VIGORTRONIX%' ) ) LIMIT 1 [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10079 LIMIT 4 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10079 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10079 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10079 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10079 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '760390013' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3466 LIMIT 4 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3466 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3466 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3466 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3466 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '44230' OR `brand` LIKE 'MYRRA%' ) ) LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`brand`,`package` FROM `stock` WHERE ( ( `status` = 1 OR `status` = 3 OR `status` = 4 OR ( `status` = 2 AND `expiretime` > '2025-09-28 06:05:30' ) ) AND `categoryid` = 621 ) ORDER BY `id` DESC LIMIT 10000 [ RunTime:0.015449s ]
SELECT COUNT(*) AS think_count FROM `stock` WHERE ( ( `status` = 1 OR `status` = 3 OR `status` = 4 OR ( `status` = 2 AND `expiretime` > '2025-09-28 06:05:30' ) ) AND `categoryid` = 621 ) [ RunTime:0.010124s ]