SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001231s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=afsb-5&search=1' [ RunTime:0.017231s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002668s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002877s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001379s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002053s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001905s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001224s ]
SELECT * FROM `stock_search` WHERE `partno` = 'afsb-5' LIMIT 1 [ RunTime:0.015715s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 14:49:44' WHERE `partno` = 'afsb-5' [ RunTime:0.005431s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001464s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023486s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018928s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078360 LIMIT 5 [ RunTime:0.013837s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078360 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078360 ORDER BY `unit` DESC [ RunTime:0.007290s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078360 LIMIT 2 [ RunTime:0.004154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078360 ORDER BY `minOrder` ASC [ RunTime:0.005312s ]
select * from pdf where partno='afsb-560-d-amt' and brandshort='swivellink' limit 1 [ RunTime:0.015591s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-560-d-amt' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.011503s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078360 AND `partno` = 'afsb-560-d-amt' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.026860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078416 LIMIT 5 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078416 ORDER BY `minOrder` ASC [ RunTime:0.014415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078416 ORDER BY `unit` DESC [ RunTime:0.013525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078416 LIMIT 2 [ RunTime:0.014887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078416 ORDER BY `minOrder` ASC [ RunTime:0.004655s ]
select * from pdf where partno='afsb-5' and brandshort='swivellink' limit 1 [ RunTime:0.037051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-5' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.005030s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078416 AND `partno` = 'afsb-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.036870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078359 LIMIT 5 [ RunTime:0.007783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078359 ORDER BY `minOrder` ASC [ RunTime:0.021671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078359 ORDER BY `unit` DESC [ RunTime:0.030833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078359 LIMIT 2 [ RunTime:0.023001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078359 ORDER BY `minOrder` ASC [ RunTime:0.003071s ]
select * from pdf where partno='afsb-540-ifm' and brandshort='swivellink' limit 1 [ RunTime:0.012729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-540-ifm' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.018778s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078359 AND `partno` = 'afsb-540-ifm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.009877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078313 LIMIT 5 [ RunTime:0.026431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078313 ORDER BY `minOrder` ASC [ RunTime:0.016818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078313 ORDER BY `unit` DESC [ RunTime:0.033153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078313 LIMIT 2 [ RunTime:0.012070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078313 ORDER BY `minOrder` ASC [ RunTime:0.007825s ]
select * from pdf where partno='afsb-530-b-p4' and brandshort='swivellink' limit 1 [ RunTime:0.003078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-530-b-p4' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.015506s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078313 AND `partno` = 'afsb-530-b-p4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.005789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078358 LIMIT 5 [ RunTime:0.012405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078358 ORDER BY `minOrder` ASC [ RunTime:0.004783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078358 ORDER BY `unit` DESC [ RunTime:0.002607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078358 LIMIT 2 [ RunTime:0.020834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078358 ORDER BY `minOrder` ASC [ RunTime:0.005030s ]
select * from pdf where partno='afsb-501-m-gtr' and brandshort='swivellink' limit 1 [ RunTime:0.004902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-501-m-gtr' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.011387s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078358 AND `partno` = 'afsb-501-m-gtr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.014811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078300 LIMIT 5 [ RunTime:0.016696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078300 ORDER BY `minOrder` ASC [ RunTime:0.010838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078300 ORDER BY `unit` DESC [ RunTime:0.011330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078300 LIMIT 2 [ RunTime:0.004816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078300 ORDER BY `minOrder` ASC [ RunTime:0.006862s ]
select * from pdf where partno='afsb-500xs-d-gb' and brandshort='swivellink' limit 1 [ RunTime:0.036317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-500xs-d-gb' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.023686s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078300 AND `partno` = 'afsb-500xs-d-gb' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.041587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078314 LIMIT 5 [ RunTime:0.035596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078314 ORDER BY `minOrder` ASC [ RunTime:0.069272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078314 ORDER BY `unit` DESC [ RunTime:0.054041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078314 LIMIT 2 [ RunTime:0.010199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078314 ORDER BY `minOrder` ASC [ RunTime:0.035360s ]
select * from pdf where partno='afsb-580-b-vs' and brandshort='swivellink' limit 1 [ RunTime:0.025512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-580-b-vs' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.021250s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078314 AND `partno` = 'afsb-580-b-vs' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.019823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078361 LIMIT 5 [ RunTime:0.063811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078361 ORDER BY `minOrder` ASC [ RunTime:0.025684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078361 ORDER BY `unit` DESC [ RunTime:0.040765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078361 LIMIT 2 [ RunTime:0.018337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078361 ORDER BY `minOrder` ASC [ RunTime:0.011379s ]
select * from pdf where partno='afsb-571-g-2320' and brandshort='swivellink' limit 1 [ RunTime:0.021914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-571-g-2320' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.028819s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078361 AND `partno` = 'afsb-571-g-2320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.004242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078417 LIMIT 5 [ RunTime:0.010338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078417 ORDER BY `minOrder` ASC [ RunTime:0.010026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078417 ORDER BY `unit` DESC [ RunTime:0.032389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078417 LIMIT 2 [ RunTime:0.022755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078417 ORDER BY `minOrder` ASC [ RunTime:0.001955s ]
select * from pdf where partno='afsb-521-c-di' and brandshort='swivellink' limit 1 [ RunTime:0.020752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-521-c-di' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.013492s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078417 AND `partno` = 'afsb-521-c-di' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.015465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078325 LIMIT 5 [ RunTime:0.065822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078325 ORDER BY `minOrder` ASC [ RunTime:0.021846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078325 ORDER BY `unit` DESC [ RunTime:0.036662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078325 LIMIT 2 [ RunTime:0.038834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078325 ORDER BY `minOrder` ASC [ RunTime:0.008390s ]
select * from pdf where partno='afsb-572-g-2340' and brandshort='swivellink' limit 1 [ RunTime:0.024404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-572-g-2340' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.026179s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078325 AND `partno` = 'afsb-572-g-2340' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.040989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078309 LIMIT 5 [ RunTime:0.038494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078309 ORDER BY `minOrder` ASC [ RunTime:0.020578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078309 ORDER BY `unit` DESC [ RunTime:0.028882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078309 LIMIT 2 [ RunTime:0.012006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078309 ORDER BY `minOrder` ASC [ RunTime:0.078423s ]
select * from pdf where partno='afsb-585-bvs-e' and brandshort='swivellink' limit 1 [ RunTime:0.030002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-585-bvs-e' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.013592s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078309 AND `partno` = 'afsb-585-bvs-e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.023131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078301 LIMIT 5 [ RunTime:0.022418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078301 ORDER BY `minOrder` ASC [ RunTime:0.027962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078301 ORDER BY `unit` DESC [ RunTime:0.007550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078301 LIMIT 2 [ RunTime:0.040686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078301 ORDER BY `minOrder` ASC [ RunTime:0.023926s ]
select * from pdf where partno='afsb-510xs-s-xc56' and brandshort='swivellink' limit 1 [ RunTime:0.037905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-510xs-s-xc56' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.025254s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078301 AND `partno` = 'afsb-510xs-s-xc56' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.008519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078303 LIMIT 5 [ RunTime:0.009098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078303 ORDER BY `minOrder` ASC [ RunTime:0.018048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078303 ORDER BY `unit` DESC [ RunTime:0.021983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078303 LIMIT 2 [ RunTime:0.023972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078303 ORDER BY `minOrder` ASC [ RunTime:0.025761s ]
select * from pdf where partno='afsb-532-b-ivu' and brandshort='swivellink' limit 1 [ RunTime:0.042867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-532-b-ivu' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.028321s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078303 AND `partno` = 'afsb-532-b-ivu' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.026116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078289 LIMIT 5 [ RunTime:0.025393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078289 ORDER BY `minOrder` ASC [ RunTime:0.027206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078289 ORDER BY `unit` DESC [ RunTime:0.015872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078289 LIMIT 2 [ RunTime:0.016786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078289 ORDER BY `minOrder` ASC [ RunTime:0.032350s ]
select * from pdf where partno='afsb-517-s-lector64x65x' and brandshort='swivellink' limit 1 [ RunTime:0.009553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-517-s-lector64x65x' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.009838s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078289 AND `partno` = 'afsb-517-s-lector64x65x' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.021400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078488 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078488 ORDER BY `minOrder` ASC [ RunTime:0.006348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078488 ORDER BY `unit` DESC [ RunTime:0.011812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078488 LIMIT 2 [ RunTime:0.017710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078488 ORDER BY `minOrder` ASC [ RunTime:0.009957s ]
select * from pdf where partno='afsb-5xs' and brandshort='swivellink' limit 1 [ RunTime:0.008282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-5xs' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.007778s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078488 AND `partno` = 'afsb-5xs' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.027005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078419 LIMIT 5 [ RunTime:0.016065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078419 ORDER BY `minOrder` ASC [ RunTime:0.014049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078419 ORDER BY `unit` DESC [ RunTime:0.017508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078419 LIMIT 2 [ RunTime:0.023191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078419 ORDER BY `minOrder` ASC [ RunTime:0.005473s ]
select * from pdf where partno='afsb-550-k-cviv' and brandshort='swivellink' limit 1 [ RunTime:0.004369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-550-k-cviv' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.002301s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078419 AND `partno` = 'afsb-550-k-cviv' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.014544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078302 LIMIT 5 [ RunTime:0.009204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078302 ORDER BY `minOrder` ASC [ RunTime:0.016202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078302 ORDER BY `unit` DESC [ RunTime:0.040388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078302 LIMIT 2 [ RunTime:0.038601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078302 ORDER BY `minOrder` ASC [ RunTime:0.014333s ]
select * from pdf where partno='afsb-520xs-c-dmic' and brandshort='swivellink' limit 1 [ RunTime:0.016408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-520xs-c-dmic' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.023790s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078302 AND `partno` = 'afsb-520xs-c-dmic' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.023617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078287 LIMIT 5 [ RunTime:0.031982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078287 ORDER BY `minOrder` ASC [ RunTime:0.022743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078287 ORDER BY `unit` DESC [ RunTime:0.014246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078287 LIMIT 2 [ RunTime:0.026555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078287 ORDER BY `minOrder` ASC [ RunTime:0.002277s ]
select * from pdf where partno='afsb-512xs-om-fq2-fh' and brandshort='swivellink' limit 1 [ RunTime:0.012696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-512xs-om-fq2-fh' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.021500s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078287 AND `partno` = 'afsb-512xs-om-fq2-fh' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.015060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078279 LIMIT 5 [ RunTime:0.010348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078279 ORDER BY `minOrder` ASC [ RunTime:0.018312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078279 ORDER BY `unit` DESC [ RunTime:0.010486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078279 LIMIT 2 [ RunTime:0.038542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078279 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
select * from pdf where partno='afsb-551xs-k-sr650-750' and brandshort='swivellink' limit 1 [ RunTime:0.010572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-551xs-k-sr650-750' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.045584s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078279 AND `partno` = 'afsb-551xs-k-sr650-750' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.101125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078418 LIMIT 5 [ RunTime:0.015350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078418 ORDER BY `minOrder` ASC [ RunTime:0.014941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078418 ORDER BY `unit` DESC [ RunTime:0.025225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078418 LIMIT 2 [ RunTime:0.014741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078418 ORDER BY `minOrder` ASC [ RunTime:0.022777s ]
select * from pdf where partno='afsb-523-c-i2000' and brandshort='swivellink' limit 1 [ RunTime:0.081915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'afsb-523-c-i2000' OR `brand` LIKE 'swivellink%' ) ) LIMIT 1 [ RunTime:0.013564s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078418 AND `partno` = 'afsb-523-c-i2000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%swivellink%' ) [ RunTime:0.025828s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029965s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017386s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006294s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010014s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017630s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015308s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029336s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017261s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'afsb-5%' OR `brand` LIKE 'afsb-5%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020794s ]