SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002619s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.077094s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.012389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14677264 LIMIT 5 [ RunTime:0.101954s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.023329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677264 ORDER BY `minOrder` ASC [ RunTime:0.081933s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.038739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14677264 ORDER BY `unit` DESC [ RunTime:0.068019s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14677264 LIMIT 2 [ RunTime:0.056509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14677264 ORDER BY `minOrder` ASC [ RunTime:0.057315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13789094 LIMIT 5 [ RunTime:0.049411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789094 ORDER BY `minOrder` ASC [ RunTime:0.046466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13789094 ORDER BY `unit` DESC [ RunTime:0.016388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13789094 LIMIT 2 [ RunTime:0.048488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13789094 ORDER BY `minOrder` ASC [ RunTime:0.030452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13791193 LIMIT 5 [ RunTime:0.044134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13791193 ORDER BY `minOrder` ASC [ RunTime:0.030509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13791193 ORDER BY `unit` DESC [ RunTime:0.055794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13791193 LIMIT 2 [ RunTime:0.016961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13791193 ORDER BY `minOrder` ASC [ RunTime:0.006906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13791186 LIMIT 5 [ RunTime:0.004652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13791186 ORDER BY `minOrder` ASC [ RunTime:0.004872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13791186 ORDER BY `unit` DESC [ RunTime:0.022365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13791186 LIMIT 2 [ RunTime:0.027750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13791186 ORDER BY `minOrder` ASC [ RunTime:0.037419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14692073 LIMIT 5 [ RunTime:0.055642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692073 ORDER BY `minOrder` ASC [ RunTime:0.011871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14692073 ORDER BY `unit` DESC [ RunTime:0.011850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14692073 LIMIT 2 [ RunTime:0.064870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14692073 ORDER BY `minOrder` ASC [ RunTime:0.009817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14685350 LIMIT 5 [ RunTime:0.017020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14685350 ORDER BY `minOrder` ASC [ RunTime:0.037909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14685350 ORDER BY `unit` DESC [ RunTime:0.029087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14685350 LIMIT 2 [ RunTime:0.017613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14685350 ORDER BY `minOrder` ASC [ RunTime:0.008957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673020 LIMIT 5 [ RunTime:0.031395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673020 ORDER BY `minOrder` ASC [ RunTime:0.011809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673020 ORDER BY `unit` DESC [ RunTime:0.028211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673020 LIMIT 2 [ RunTime:0.031554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673020 ORDER BY `minOrder` ASC [ RunTime:0.014287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123814 LIMIT 5 [ RunTime:0.025920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123814 ORDER BY `minOrder` ASC [ RunTime:0.014061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20123814 ORDER BY `unit` DESC [ RunTime:0.015138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20123814 LIMIT 2 [ RunTime:0.009753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123814 ORDER BY `minOrder` ASC [ RunTime:0.006205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123813 LIMIT 5 [ RunTime:0.004891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123813 ORDER BY `minOrder` ASC [ RunTime:0.013682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20123813 ORDER BY `unit` DESC [ RunTime:0.006810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20123813 LIMIT 2 [ RunTime:0.023728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123813 ORDER BY `minOrder` ASC [ RunTime:0.014686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143577 LIMIT 5 [ RunTime:0.014619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143577 ORDER BY `minOrder` ASC [ RunTime:0.014217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17143577 ORDER BY `unit` DESC [ RunTime:0.008510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17143577 LIMIT 2 [ RunTime:0.011332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17143577 ORDER BY `minOrder` ASC [ RunTime:0.002906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16620350 LIMIT 5 [ RunTime:0.011976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620350 ORDER BY `minOrder` ASC [ RunTime:0.002978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16620350 ORDER BY `unit` DESC [ RunTime:0.003409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16620350 LIMIT 2 [ RunTime:0.001411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16620350 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15453175 LIMIT 5 [ RunTime:0.002223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453175 ORDER BY `minOrder` ASC [ RunTime:0.005355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15453175 ORDER BY `unit` DESC [ RunTime:0.001306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15453175 LIMIT 2 [ RunTime:0.003339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15453175 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14709986 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709986 ORDER BY `minOrder` ASC [ RunTime:0.008986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14709986 ORDER BY `unit` DESC [ RunTime:0.001991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14709986 LIMIT 2 [ RunTime:0.006648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14709986 ORDER BY `minOrder` ASC [ RunTime:0.004195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14696154 LIMIT 5 [ RunTime:0.001248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696154 ORDER BY `minOrder` ASC [ RunTime:0.002300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14696154 ORDER BY `unit` DESC [ RunTime:0.001767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14696154 LIMIT 2 [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14696154 ORDER BY `minOrder` ASC [ RunTime:0.004280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257584 LIMIT 5 [ RunTime:0.003851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257584 ORDER BY `minOrder` ASC [ RunTime:0.008030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14257584 ORDER BY `unit` DESC [ RunTime:0.001450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14257584 LIMIT 2 [ RunTime:0.006464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14257584 ORDER BY `minOrder` ASC [ RunTime:0.004155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13819621 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13819621 ORDER BY `minOrder` ASC [ RunTime:0.003200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13819621 ORDER BY `unit` DESC [ RunTime:0.005283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13819621 LIMIT 2 [ RunTime:0.001051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13819621 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13819610 LIMIT 5 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13819610 ORDER BY `minOrder` ASC [ RunTime:0.003942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13819610 ORDER BY `unit` DESC [ RunTime:0.001229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13819610 LIMIT 2 [ RunTime:0.004491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13819610 ORDER BY `minOrder` ASC [ RunTime:0.009369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13807960 LIMIT 5 [ RunTime:0.008146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807960 ORDER BY `minOrder` ASC [ RunTime:0.005528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13807960 ORDER BY `unit` DESC [ RunTime:0.008587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13807960 LIMIT 2 [ RunTime:0.012800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13807960 ORDER BY `minOrder` ASC [ RunTime:0.006990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11449771 LIMIT 5 [ RunTime:0.007381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11449771 ORDER BY `minOrder` ASC [ RunTime:0.011139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11449771 ORDER BY `unit` DESC [ RunTime:0.013726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11449771 LIMIT 2 [ RunTime:0.010443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11449771 ORDER BY `minOrder` ASC [ RunTime:0.004534s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010314s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62128165 LIMIT 5 [ RunTime:0.003273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62128165 ORDER BY `minOrder` ASC [ RunTime:0.013824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62128165 ORDER BY `unit` DESC [ RunTime:0.001535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62128165 LIMIT 2 [ RunTime:0.009466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62128165 ORDER BY `minOrder` ASC [ RunTime:0.001577s ]
select * from pdf where partno='1522927' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003307s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522927' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62128207 LIMIT 5 [ RunTime:0.009063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62128207 ORDER BY `minOrder` ASC [ RunTime:0.001182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62128207 ORDER BY `unit` DESC [ RunTime:0.001744s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62128207 LIMIT 2 [ RunTime:0.006250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62128207 ORDER BY `minOrder` ASC [ RunTime:0.005220s ]
select * from pdf where partno='1522972' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522972' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62130964 LIMIT 5 [ RunTime:0.025731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62130964 ORDER BY `minOrder` ASC [ RunTime:0.015294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62130964 ORDER BY `unit` DESC [ RunTime:0.008111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62130964 LIMIT 2 [ RunTime:0.002741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62130964 ORDER BY `minOrder` ASC [ RunTime:0.004734s ]
select * from pdf where partno='1522943' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522943' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.019786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62130923 LIMIT 5 [ RunTime:0.026567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62130923 ORDER BY `minOrder` ASC [ RunTime:0.006431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62130923 ORDER BY `unit` DESC [ RunTime:0.021814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62130923 LIMIT 2 [ RunTime:0.002743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62130923 ORDER BY `minOrder` ASC [ RunTime:0.007830s ]
select * from pdf where partno='1522930' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522930' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62132389 LIMIT 5 [ RunTime:0.006032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62132389 ORDER BY `minOrder` ASC [ RunTime:0.002302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62132389 ORDER BY `unit` DESC [ RunTime:0.005334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62132389 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62132389 ORDER BY `minOrder` ASC [ RunTime:0.003484s ]
select * from pdf where partno='1522985' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.007372s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522985' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62140631 LIMIT 5 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140631 ORDER BY `minOrder` ASC [ RunTime:0.001327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62140631 ORDER BY `unit` DESC [ RunTime:0.004032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62140631 LIMIT 2 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140631 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='1522969' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522969' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62140316 LIMIT 5 [ RunTime:0.001715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140316 ORDER BY `minOrder` ASC [ RunTime:0.001037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62140316 ORDER BY `unit` DESC [ RunTime:0.001745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62140316 LIMIT 2 [ RunTime:0.005304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62140316 ORDER BY `minOrder` ASC [ RunTime:0.001081s ]
select * from pdf where partno='1522914' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522914' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.018721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62138377 LIMIT 5 [ RunTime:0.009750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138377 ORDER BY `minOrder` ASC [ RunTime:0.015855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62138377 ORDER BY `unit` DESC [ RunTime:0.016271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62138377 LIMIT 2 [ RunTime:0.007019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62138377 ORDER BY `minOrder` ASC [ RunTime:0.006571s ]
select * from pdf where partno='1522998' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1522998' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59351021 LIMIT 5 [ RunTime:0.004890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59351021 ORDER BY `minOrder` ASC [ RunTime:0.009338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59351021 ORDER BY `unit` DESC [ RunTime:0.012896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59351021 LIMIT 2 [ RunTime:0.006620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59351021 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
select * from pdf where partno='15229' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.007069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15229' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002689s ]
SELECT `id` FROM `stock` WHERE `id` <> 59351021 AND `partno` = '15229' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.008180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11449771 [ RunTime:0.005167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43772218 LIMIT 5 [ RunTime:0.007767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43772218 ORDER BY `minOrder` ASC [ RunTime:0.005517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43772218 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43772218 LIMIT 2 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43772218 ORDER BY `minOrder` ASC [ RunTime:0.007397s ]
select * from pdf where partno='15229.2' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.005257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15229.2' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.004329s ]
SELECT `id` FROM `stock` WHERE `id` <> 43772218 AND `partno` = '15229.2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.013660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17143577 [ RunTime:0.003236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37930788 LIMIT 5 [ RunTime:0.003633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37930788 ORDER BY `minOrder` ASC [ RunTime:0.002967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37930788 ORDER BY `unit` DESC [ RunTime:0.005953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37930788 LIMIT 2 [ RunTime:0.006926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37930788 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
select * from pdf where partno='15229' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.002778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15229' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.002834s ]
SELECT `id` FROM `stock` WHERE `id` <> 37930788 AND `partno` = '15229' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.004175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14257584 [ RunTime:0.004759s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008841s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002274s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003065s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010623s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003838s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015361s ]
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 '15229%' OR `brand` LIKE '15229%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008678s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15229%' OR `brand` LIKE '15229%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009447s ]