SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001550s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031640s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12189891 LIMIT 5 [ RunTime:0.030400s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12189891 ORDER BY `minOrder` ASC [ RunTime:0.014607s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12189891 ORDER BY `unit` DESC [ RunTime:0.011361s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12189891 LIMIT 2 [ RunTime:0.024174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12189891 ORDER BY `minOrder` ASC [ RunTime:0.012350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190842 LIMIT 5 [ RunTime:0.068464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190842 ORDER BY `minOrder` ASC [ RunTime:0.047215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190842 ORDER BY `unit` DESC [ RunTime:0.022497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190842 LIMIT 2 [ RunTime:0.018160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190842 ORDER BY `minOrder` ASC [ RunTime:0.008234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11201165 LIMIT 5 [ RunTime:0.005247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11201165 ORDER BY `minOrder` ASC [ RunTime:0.017421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11201165 ORDER BY `unit` DESC [ RunTime:0.052216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11201165 LIMIT 2 [ RunTime:0.043468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11201165 ORDER BY `minOrder` ASC [ RunTime:0.024809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787076 LIMIT 5 [ RunTime:0.027142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787076 ORDER BY `minOrder` ASC [ RunTime:0.022720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18787076 ORDER BY `unit` DESC [ RunTime:0.043217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18787076 LIMIT 2 [ RunTime:0.013527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787076 ORDER BY `minOrder` ASC [ RunTime:0.021276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786862 LIMIT 5 [ RunTime:0.026302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786862 ORDER BY `minOrder` ASC [ RunTime:0.029413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786862 ORDER BY `unit` DESC [ RunTime:0.073096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786862 LIMIT 2 [ RunTime:0.003989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786862 ORDER BY `minOrder` ASC [ RunTime:0.011118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786861 LIMIT 5 [ RunTime:0.005044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786861 ORDER BY `minOrder` ASC [ RunTime:0.015295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18786861 ORDER BY `unit` DESC [ RunTime:0.027980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18786861 LIMIT 2 [ RunTime:0.025836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18786861 ORDER BY `minOrder` ASC [ RunTime:0.010656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226324 LIMIT 5 [ RunTime:0.011995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226324 ORDER BY `minOrder` ASC [ RunTime:0.060702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226324 ORDER BY `unit` DESC [ RunTime:0.017588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226324 LIMIT 2 [ RunTime:0.034732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226324 ORDER BY `minOrder` ASC [ RunTime:0.009043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226254 LIMIT 5 [ RunTime:0.014235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226254 ORDER BY `minOrder` ASC [ RunTime:0.010586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226254 ORDER BY `unit` DESC [ RunTime:0.055357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226254 LIMIT 2 [ RunTime:0.029908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226254 ORDER BY `minOrder` ASC [ RunTime:0.053961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226253 LIMIT 5 [ RunTime:0.036255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226253 ORDER BY `minOrder` ASC [ RunTime:0.107693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15226253 ORDER BY `unit` DESC [ RunTime:0.072724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15226253 LIMIT 2 [ RunTime:0.029757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15226253 ORDER BY `minOrder` ASC [ RunTime:0.043916s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080809 LIMIT 5 [ RunTime:0.024068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080809 ORDER BY `minOrder` ASC [ RunTime:0.067154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080809 ORDER BY `unit` DESC [ RunTime:0.030361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080809 LIMIT 2 [ RunTime:0.041835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080809 ORDER BY `minOrder` ASC [ RunTime:0.015607s ]
select * from pdf where partno='106588' and brandshort='basler' limit 1 [ RunTime:0.013607s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106588' OR `brand` LIKE 'basler%' ) ) LIMIT 1 [ RunTime:0.034712s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336679 LIMIT 5 [ RunTime:0.009685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336679 ORDER BY `minOrder` ASC [ RunTime:0.006144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336679 ORDER BY `unit` DESC [ RunTime:0.005987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336679 LIMIT 2 [ RunTime:0.010296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336679 ORDER BY `minOrder` ASC [ RunTime:0.002297s ]
select * from pdf where partno='1065887' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065887' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016910s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336679 AND `partno` = '1065887' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11201165 [ RunTime:0.013557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336176 LIMIT 5 [ RunTime:0.014510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336176 ORDER BY `minOrder` ASC [ RunTime:0.009551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336176 ORDER BY `unit` DESC [ RunTime:0.004923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336176 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336176 ORDER BY `minOrder` ASC [ RunTime:0.006097s ]
select * from pdf where partno='1065886' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065886' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336176 AND `partno` = '1065886' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12189891 [ RunTime:0.005620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336146 LIMIT 5 [ RunTime:0.001561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336146 ORDER BY `minOrder` ASC [ RunTime:0.001282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336146 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336146 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336146 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
select * from pdf where partno='1065885' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000857s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065885' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002685s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336146 AND `partno` = '1065885' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190842 [ RunTime:0.003519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63341300 LIMIT 5 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63341300 ORDER BY `minOrder` ASC [ RunTime:0.001117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63341300 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63341300 LIMIT 2 [ RunTime:0.002035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63341300 ORDER BY `minOrder` ASC [ RunTime:0.005855s ]
select * from pdf where partno='1065889' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004078s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065889' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000842s ]
SELECT `id` FROM `stock` WHERE `id` <> 63341300 AND `partno` = '1065889' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226324 [ RunTime:0.000621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340944 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340944 ORDER BY `minOrder` ASC [ RunTime:0.002012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340944 ORDER BY `unit` DESC [ RunTime:0.002803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340944 LIMIT 2 [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340944 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='1065888' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065888' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006091s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340944 AND `partno` = '1065888' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226254 [ RunTime:0.001394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340943 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340943 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340943 ORDER BY `unit` DESC [ RunTime:0.007562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340943 LIMIT 2 [ RunTime:0.003436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340943 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='1065884' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065884' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000596s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340943 AND `partno` = '1065884' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15226253 [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340942 LIMIT 5 [ RunTime:0.005947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340942 ORDER BY `minOrder` ASC [ RunTime:0.016303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340942 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340942 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340942 ORDER BY `minOrder` ASC [ RunTime:0.002956s ]
select * from pdf where partno='1065882' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065882' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001084s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340942 AND `partno` = '1065882' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787076 [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340635 LIMIT 5 [ RunTime:0.015813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340635 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340635 ORDER BY `unit` DESC [ RunTime:0.009405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340635 LIMIT 2 [ RunTime:0.014065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340635 ORDER BY `minOrder` ASC [ RunTime:0.009278s ]
select * from pdf where partno='1065883' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065883' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001854s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340635 AND `partno` = '1065883' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786862 [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63340634 LIMIT 5 [ RunTime:0.007814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340634 ORDER BY `minOrder` ASC [ RunTime:0.011758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63340634 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63340634 LIMIT 2 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63340634 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
select * from pdf where partno='1065880' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1065880' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.033079s ]
SELECT `id` FROM `stock` WHERE `id` <> 63340634 AND `partno` = '1065880' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18786861 [ RunTime:0.018549s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001567s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006130s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023057s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018832s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012869s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038193s ]
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 '106588%' OR `brand` LIKE '106588%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004755s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '106588%' OR `brand` LIKE '106588%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025267s ]