SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001466s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=56422&search=1' [ RunTime:0.002865s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001125s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000639s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001698s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000919s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001365s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002254s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001631s ]
SELECT * FROM `stock_search` WHERE `partno` = '56422' LIMIT 1 [ RunTime:0.002596s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 11:15:57' WHERE `partno` = '56422' [ RunTime:0.028510s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002716s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025447s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18908778 LIMIT 5 [ RunTime:0.022973s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908778 ORDER BY `minOrder` ASC [ RunTime:0.014432s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18908778 ORDER BY `unit` DESC [ RunTime:0.010337s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18908778 LIMIT 2 [ RunTime:0.017465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18908778 ORDER BY `minOrder` ASC [ RunTime:0.019289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907589 LIMIT 5 [ RunTime:0.051025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907589 ORDER BY `minOrder` ASC [ RunTime:0.062773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18907589 ORDER BY `unit` DESC [ RunTime:0.063309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18907589 LIMIT 2 [ RunTime:0.038133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18907589 ORDER BY `minOrder` ASC [ RunTime:0.012974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906882 LIMIT 5 [ RunTime:0.038746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906882 ORDER BY `minOrder` ASC [ RunTime:0.023301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906882 ORDER BY `unit` DESC [ RunTime:0.056041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906882 LIMIT 2 [ RunTime:0.022326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906882 ORDER BY `minOrder` ASC [ RunTime:0.062517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906818 LIMIT 5 [ RunTime:0.031380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906818 ORDER BY `minOrder` ASC [ RunTime:0.010543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906818 ORDER BY `unit` DESC [ RunTime:0.028639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906818 LIMIT 2 [ RunTime:0.024355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906818 ORDER BY `minOrder` ASC [ RunTime:0.023532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906817 LIMIT 5 [ RunTime:0.006547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906817 ORDER BY `minOrder` ASC [ RunTime:0.044114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906817 ORDER BY `unit` DESC [ RunTime:0.066087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906817 LIMIT 2 [ RunTime:0.027516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906817 ORDER BY `minOrder` ASC [ RunTime:0.002404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906816 LIMIT 5 [ RunTime:0.031372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906816 ORDER BY `minOrder` ASC [ RunTime:0.048878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906816 ORDER BY `unit` DESC [ RunTime:0.015709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906816 LIMIT 2 [ RunTime:0.019716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906816 ORDER BY `minOrder` ASC [ RunTime:0.026634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906815 LIMIT 5 [ RunTime:0.009450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906815 ORDER BY `minOrder` ASC [ RunTime:0.006215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906815 ORDER BY `unit` DESC [ RunTime:0.039733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906815 LIMIT 2 [ RunTime:0.030489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906815 ORDER BY `minOrder` ASC [ RunTime:0.002444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906814 LIMIT 5 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906814 ORDER BY `minOrder` ASC [ RunTime:0.016073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906814 ORDER BY `unit` DESC [ RunTime:0.056626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906814 LIMIT 2 [ RunTime:0.011335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906814 ORDER BY `minOrder` ASC [ RunTime:0.009743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906813 LIMIT 5 [ RunTime:0.019192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906813 ORDER BY `minOrder` ASC [ RunTime:0.019922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906813 ORDER BY `unit` DESC [ RunTime:0.016877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906813 LIMIT 2 [ RunTime:0.039184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906813 ORDER BY `minOrder` ASC [ RunTime:0.010021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906812 LIMIT 5 [ RunTime:0.015289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906812 ORDER BY `minOrder` ASC [ RunTime:0.027180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906812 ORDER BY `unit` DESC [ RunTime:0.034179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906812 LIMIT 2 [ RunTime:0.010141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906812 ORDER BY `minOrder` ASC [ RunTime:0.012547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906811 LIMIT 5 [ RunTime:0.048170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906811 ORDER BY `minOrder` ASC [ RunTime:0.033547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906811 ORDER BY `unit` DESC [ RunTime:0.019402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906811 LIMIT 2 [ RunTime:0.027220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906811 ORDER BY `minOrder` ASC [ RunTime:0.016570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906742 LIMIT 5 [ RunTime:0.015755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906742 ORDER BY `minOrder` ASC [ RunTime:0.012536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906742 ORDER BY `unit` DESC [ RunTime:0.030490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906742 LIMIT 2 [ RunTime:0.027558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906742 ORDER BY `minOrder` ASC [ RunTime:0.010285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906703 LIMIT 5 [ RunTime:0.020118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906703 ORDER BY `minOrder` ASC [ RunTime:0.082471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906703 ORDER BY `unit` DESC [ RunTime:0.075255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906703 LIMIT 2 [ RunTime:0.076003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906703 ORDER BY `minOrder` ASC [ RunTime:0.026592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906598 LIMIT 5 [ RunTime:0.034027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906598 ORDER BY `minOrder` ASC [ RunTime:0.034971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906598 ORDER BY `unit` DESC [ RunTime:0.066968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906598 LIMIT 2 [ RunTime:0.047505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906598 ORDER BY `minOrder` ASC [ RunTime:0.012621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906597 LIMIT 5 [ RunTime:0.030387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906597 ORDER BY `minOrder` ASC [ RunTime:0.032218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906597 ORDER BY `unit` DESC [ RunTime:0.054606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906597 LIMIT 2 [ RunTime:0.006230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906597 ORDER BY `minOrder` ASC [ RunTime:0.031456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906495 LIMIT 5 [ RunTime:0.040276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906495 ORDER BY `minOrder` ASC [ RunTime:0.020788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906495 ORDER BY `unit` DESC [ RunTime:0.048517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906495 LIMIT 2 [ RunTime:0.040020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906495 ORDER BY `minOrder` ASC [ RunTime:0.002930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906494 LIMIT 5 [ RunTime:0.021485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906494 ORDER BY `minOrder` ASC [ RunTime:0.023099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906494 ORDER BY `unit` DESC [ RunTime:0.013338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906494 LIMIT 2 [ RunTime:0.010714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906494 ORDER BY `minOrder` ASC [ RunTime:0.012474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906493 LIMIT 5 [ RunTime:0.020001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906493 ORDER BY `minOrder` ASC [ RunTime:0.033756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906493 ORDER BY `unit` DESC [ RunTime:0.028296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906493 LIMIT 2 [ RunTime:0.007102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906493 ORDER BY `minOrder` ASC [ RunTime:0.005598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906467 LIMIT 5 [ RunTime:0.009605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906467 ORDER BY `minOrder` ASC [ RunTime:0.029322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906467 ORDER BY `unit` DESC [ RunTime:0.024351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906467 LIMIT 2 [ RunTime:0.044974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906467 ORDER BY `minOrder` ASC [ RunTime:0.019971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906247 LIMIT 5 [ RunTime:0.026915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906247 ORDER BY `minOrder` ASC [ RunTime:0.036495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906247 ORDER BY `unit` DESC [ RunTime:0.023819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906247 LIMIT 2 [ RunTime:0.020133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906247 ORDER BY `minOrder` ASC [ RunTime:0.013908s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010112s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246934 LIMIT 5 [ RunTime:0.026578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246934 ORDER BY `minOrder` ASC [ RunTime:0.040795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246934 ORDER BY `unit` DESC [ RunTime:0.055961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246934 LIMIT 2 [ RunTime:0.032242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246934 ORDER BY `minOrder` ASC [ RunTime:0.014672s ]
select * from pdf where partno='5642210123F' and brandshort='Dialight' limit 1 [ RunTime:0.024942s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210123F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.027295s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246934 AND `partno` = '5642210123F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.044384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18907589 [ RunTime:0.063489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246933 LIMIT 5 [ RunTime:0.007876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246933 ORDER BY `minOrder` ASC [ RunTime:0.037147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246933 ORDER BY `unit` DESC [ RunTime:0.047951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246933 LIMIT 2 [ RunTime:0.079690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246933 ORDER BY `minOrder` ASC [ RunTime:0.024728s ]
select * from pdf where partno='5642210111F' and brandshort='Dialight' limit 1 [ RunTime:0.054262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210111F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.042723s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246933 AND `partno` = '5642210111F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.058461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250221 [ RunTime:0.083412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246492 LIMIT 5 [ RunTime:0.055345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246492 ORDER BY `minOrder` ASC [ RunTime:0.080630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246492 ORDER BY `unit` DESC [ RunTime:0.057642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246492 LIMIT 2 [ RunTime:0.024393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246492 ORDER BY `minOrder` ASC [ RunTime:0.032647s ]
select * from pdf where partno='5642210816F' and brandshort='Dialight' limit 1 [ RunTime:0.042127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210816F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.051748s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246492 AND `partno` = '5642210816F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.061386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250137 [ RunTime:0.027931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246491 LIMIT 5 [ RunTime:0.008109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246491 ORDER BY `minOrder` ASC [ RunTime:0.041137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246491 ORDER BY `unit` DESC [ RunTime:0.043277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246491 LIMIT 2 [ RunTime:0.049286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246491 ORDER BY `minOrder` ASC [ RunTime:0.045081s ]
select * from pdf where partno='5642210293F' and brandshort='Dialight' limit 1 [ RunTime:0.026326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210293F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.061912s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246491 AND `partno` = '5642210293F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.028255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250136 [ RunTime:0.052935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246143 LIMIT 5 [ RunTime:0.016675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246143 ORDER BY `minOrder` ASC [ RunTime:0.033488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246143 ORDER BY `unit` DESC [ RunTime:0.055630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246143 LIMIT 2 [ RunTime:0.015617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246143 ORDER BY `minOrder` ASC [ RunTime:0.010743s ]
select * from pdf where partno='5642210113F' and brandshort='Dialight' limit 1 [ RunTime:0.025557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210113F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.029031s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246143 AND `partno` = '5642210113F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.070047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906882 [ RunTime:0.025215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246110 LIMIT 5 [ RunTime:0.052151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246110 ORDER BY `minOrder` ASC [ RunTime:0.044748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246110 ORDER BY `unit` DESC [ RunTime:0.054449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246110 LIMIT 2 [ RunTime:0.029997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246110 ORDER BY `minOrder` ASC [ RunTime:0.044058s ]
select * from pdf where partno='5642210814F' and brandshort='Dialight' limit 1 [ RunTime:0.061920s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210814F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.041980s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246110 AND `partno` = '5642210814F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.034111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250083 [ RunTime:0.043197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246064 LIMIT 5 [ RunTime:0.000914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246064 ORDER BY `minOrder` ASC [ RunTime:0.068502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246064 ORDER BY `unit` DESC [ RunTime:0.034901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246064 LIMIT 2 [ RunTime:0.037631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246064 ORDER BY `minOrder` ASC [ RunTime:0.046566s ]
select * from pdf where partno='5642210333F' and brandshort='Dialight' limit 1 [ RunTime:0.016587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210333F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.011683s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246064 AND `partno` = '5642210333F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.018949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906818 [ RunTime:0.039762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246063 LIMIT 5 [ RunTime:0.025739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246063 ORDER BY `minOrder` ASC [ RunTime:0.018711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246063 ORDER BY `unit` DESC [ RunTime:0.012553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246063 LIMIT 2 [ RunTime:0.050388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246063 ORDER BY `minOrder` ASC [ RunTime:0.012926s ]
select * from pdf where partno='5642200808F' and brandshort='Dialight' limit 1 [ RunTime:0.029275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200808F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.021654s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246063 AND `partno` = '5642200808F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.028024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906815 [ RunTime:0.028730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246062 LIMIT 5 [ RunTime:0.032281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246062 ORDER BY `minOrder` ASC [ RunTime:0.012367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246062 ORDER BY `unit` DESC [ RunTime:0.026868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246062 LIMIT 2 [ RunTime:0.052950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246062 ORDER BY `minOrder` ASC [ RunTime:0.033957s ]
select * from pdf where partno='5642200807F' and brandshort='Dialight' limit 1 [ RunTime:0.036466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200807F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.036017s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246062 AND `partno` = '5642200807F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.035810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906814 [ RunTime:0.050369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246061 LIMIT 5 [ RunTime:0.027938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246061 ORDER BY `minOrder` ASC [ RunTime:0.038599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246061 ORDER BY `unit` DESC [ RunTime:0.014054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246061 LIMIT 2 [ RunTime:0.049198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246061 ORDER BY `minOrder` ASC [ RunTime:0.033408s ]
select * from pdf where partno='5642200802F' and brandshort='Dialight' limit 1 [ RunTime:0.038626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200802F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.018506s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246061 AND `partno` = '5642200802F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.046755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034279 [ RunTime:0.014704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246027 LIMIT 5 [ RunTime:0.022663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246027 ORDER BY `minOrder` ASC [ RunTime:0.018256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246027 ORDER BY `unit` DESC [ RunTime:0.005641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246027 LIMIT 2 [ RunTime:0.022609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246027 ORDER BY `minOrder` ASC [ RunTime:0.016136s ]
select * from pdf where partno='5642210332F' and brandshort='Dialight' limit 1 [ RunTime:0.010678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210332F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.050723s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246027 AND `partno` = '5642210332F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.030791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906817 [ RunTime:0.006169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246026 LIMIT 5 [ RunTime:0.017000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246026 ORDER BY `minOrder` ASC [ RunTime:0.032122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246026 ORDER BY `unit` DESC [ RunTime:0.023050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246026 LIMIT 2 [ RunTime:0.017338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246026 ORDER BY `minOrder` ASC [ RunTime:0.006804s ]
select * from pdf where partno='5642210122F' and brandshort='Dialight' limit 1 [ RunTime:0.023652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210122F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.027335s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246026 AND `partno` = '5642210122F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.042050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906816 [ RunTime:0.021425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246025 LIMIT 5 [ RunTime:0.014145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246025 ORDER BY `minOrder` ASC [ RunTime:0.028723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246025 ORDER BY `unit` DESC [ RunTime:0.019244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246025 LIMIT 2 [ RunTime:0.028638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246025 ORDER BY `minOrder` ASC [ RunTime:0.002061s ]
select * from pdf where partno='5642200806F' and brandshort='Dialight' limit 1 [ RunTime:0.023035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200806F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.037277s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246025 AND `partno` = '5642200806F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.056868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906813 [ RunTime:0.008107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246024 LIMIT 5 [ RunTime:0.038007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246024 ORDER BY `minOrder` ASC [ RunTime:0.047094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246024 ORDER BY `unit` DESC [ RunTime:0.009776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246024 LIMIT 2 [ RunTime:0.054335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246024 ORDER BY `minOrder` ASC [ RunTime:0.029664s ]
select * from pdf where partno='5642200805F' and brandshort='Dialight' limit 1 [ RunTime:0.020847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200805F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.041775s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246024 AND `partno` = '5642200805F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.060525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906812 [ RunTime:0.016352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246023 LIMIT 5 [ RunTime:0.017557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246023 ORDER BY `minOrder` ASC [ RunTime:0.070995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246023 ORDER BY `unit` DESC [ RunTime:0.038705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246023 LIMIT 2 [ RunTime:0.077226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246023 ORDER BY `minOrder` ASC [ RunTime:0.032321s ]
select * from pdf where partno='5642200804F' and brandshort='Dialight' limit 1 [ RunTime:0.029172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200804F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.068361s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246023 AND `partno` = '5642200804F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.035219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906811 [ RunTime:0.016060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51246022 LIMIT 5 [ RunTime:0.039438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246022 ORDER BY `minOrder` ASC [ RunTime:0.025764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51246022 ORDER BY `unit` DESC [ RunTime:0.018586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51246022 LIMIT 2 [ RunTime:0.012535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51246022 ORDER BY `minOrder` ASC [ RunTime:0.010851s ]
select * from pdf where partno='5642200801F' and brandshort='Dialight' limit 1 [ RunTime:0.035850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200801F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.029134s ]
SELECT `id` FROM `stock` WHERE `id` <> 51246022 AND `partno` = '5642200801F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.038482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034278 [ RunTime:0.039025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245957 LIMIT 5 [ RunTime:0.035969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245957 ORDER BY `minOrder` ASC [ RunTime:0.024629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245957 ORDER BY `unit` DESC [ RunTime:0.025331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245957 LIMIT 2 [ RunTime:0.029622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245957 ORDER BY `minOrder` ASC [ RunTime:0.016154s ]
select * from pdf where partno='5642210133F' and brandshort='Dialight' limit 1 [ RunTime:0.008907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210133F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.018604s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245957 AND `partno` = '5642210133F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.029341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034268 [ RunTime:0.044023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245944 LIMIT 5 [ RunTime:0.003471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245944 ORDER BY `minOrder` ASC [ RunTime:0.003929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245944 ORDER BY `unit` DESC [ RunTime:0.017098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245944 LIMIT 2 [ RunTime:0.024012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245944 ORDER BY `minOrder` ASC [ RunTime:0.002805s ]
select * from pdf where partno='5642210813F' and brandshort='Dialight' limit 1 [ RunTime:0.023138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210813F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.009672s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245944 AND `partno` = '5642210813F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.033877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906742 [ RunTime:0.014279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245920 LIMIT 5 [ RunTime:0.026111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245920 ORDER BY `minOrder` ASC [ RunTime:0.018332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245920 ORDER BY `unit` DESC [ RunTime:0.034701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245920 LIMIT 2 [ RunTime:0.023102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245920 ORDER BY `minOrder` ASC [ RunTime:0.007600s ]
select * from pdf where partno='5642200332F' and brandshort='Dialight' limit 1 [ RunTime:0.010952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642200332F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.016711s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245920 AND `partno` = '5642200332F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.019155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906703 [ RunTime:0.035398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51245784 LIMIT 5 [ RunTime:0.045786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245784 ORDER BY `minOrder` ASC [ RunTime:0.038120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51245784 ORDER BY `unit` DESC [ RunTime:0.037684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51245784 LIMIT 2 [ RunTime:0.012723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51245784 ORDER BY `minOrder` ASC [ RunTime:0.002056s ]
select * from pdf where partno='5642210809F' and brandshort='Dialight' limit 1 [ RunTime:0.040623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5642210809F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.012586s ]
SELECT `id` FROM `stock` WHERE `id` <> 51245784 AND `partno` = '5642210809F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.033130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15250037 [ RunTime:0.039470s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026933s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024593s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021594s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013496s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023220s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023358s ]
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 '56422%' OR `brand` LIKE '56422%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022172s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '56422%' OR `brand` LIKE '56422%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.037215s ]