SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002331s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024483s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186034 LIMIT 5 [ RunTime:0.042566s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186034 ORDER BY `minOrder` ASC [ RunTime:0.022631s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186034 ORDER BY `unit` DESC [ RunTime:0.029445s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186034 LIMIT 2 [ RunTime:0.020935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186034 ORDER BY `minOrder` ASC [ RunTime:0.052160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185200 LIMIT 5 [ RunTime:0.028029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185200 ORDER BY `minOrder` ASC [ RunTime:0.016853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12185200 ORDER BY `unit` DESC [ RunTime:0.052977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12185200 LIMIT 2 [ RunTime:0.032727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185200 ORDER BY `minOrder` ASC [ RunTime:0.029015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177014 LIMIT 5 [ RunTime:0.081535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177014 ORDER BY `minOrder` ASC [ RunTime:0.004487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12177014 ORDER BY `unit` DESC [ RunTime:0.012117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12177014 LIMIT 2 [ RunTime:0.011774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12177014 ORDER BY `minOrder` ASC [ RunTime:0.018082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12176429 LIMIT 5 [ RunTime:0.030899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12176429 ORDER BY `minOrder` ASC [ RunTime:0.063965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12176429 ORDER BY `unit` DESC [ RunTime:0.080196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12176429 LIMIT 2 [ RunTime:0.065591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12176429 ORDER BY `minOrder` ASC [ RunTime:0.035884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12176427 LIMIT 5 [ RunTime:0.019254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12176427 ORDER BY `minOrder` ASC [ RunTime:0.029846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12176427 ORDER BY `unit` DESC [ RunTime:0.016641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12176427 LIMIT 2 [ RunTime:0.070157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12176427 ORDER BY `minOrder` ASC [ RunTime:0.016299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175947 LIMIT 5 [ RunTime:0.013038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175947 ORDER BY `minOrder` ASC [ RunTime:0.015056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175947 ORDER BY `unit` DESC [ RunTime:0.007456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175947 LIMIT 2 [ RunTime:0.012240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175947 ORDER BY `minOrder` ASC [ RunTime:0.024241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175945 LIMIT 5 [ RunTime:0.022573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175945 ORDER BY `minOrder` ASC [ RunTime:0.020223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175945 ORDER BY `unit` DESC [ RunTime:0.030502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175945 LIMIT 2 [ RunTime:0.016435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175945 ORDER BY `minOrder` ASC [ RunTime:0.007268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175935 LIMIT 5 [ RunTime:0.016040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175935 ORDER BY `minOrder` ASC [ RunTime:0.004612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175935 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175935 LIMIT 2 [ RunTime:0.009076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175935 ORDER BY `minOrder` ASC [ RunTime:0.010447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175773 LIMIT 5 [ RunTime:0.004598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175773 ORDER BY `minOrder` ASC [ RunTime:0.002520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175773 ORDER BY `unit` DESC [ RunTime:0.000821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175773 LIMIT 2 [ RunTime:0.001900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175773 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175409 LIMIT 5 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175409 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12175409 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12175409 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12175409 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12174528 LIMIT 5 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174528 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12174528 ORDER BY `unit` DESC [ RunTime:0.002188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12174528 LIMIT 2 [ RunTime:0.001477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12174528 ORDER BY `minOrder` ASC [ RunTime:0.001705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190074 LIMIT 5 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190074 ORDER BY `minOrder` ASC [ RunTime:0.012191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11190074 ORDER BY `unit` DESC [ RunTime:0.007821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11190074 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11190074 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11189504 LIMIT 5 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189504 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11189504 ORDER BY `unit` DESC [ RunTime:0.016004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11189504 LIMIT 2 [ RunTime:0.006938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11189504 ORDER BY `minOrder` ASC [ RunTime:0.003327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186386 LIMIT 5 [ RunTime:0.010031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186386 ORDER BY `minOrder` ASC [ RunTime:0.008390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186386 ORDER BY `unit` DESC [ RunTime:0.005340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186386 LIMIT 2 [ RunTime:0.002701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186386 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001720s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58555119 LIMIT 5 [ RunTime:0.002228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555119 ORDER BY `minOrder` ASC [ RunTime:0.009661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58555119 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58555119 LIMIT 2 [ RunTime:0.000369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555119 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='KL-0124-43' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001883s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-43' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000548s ]
SELECT `id` FROM `stock` WHERE `id` <> 58555119 AND `partno` = 'KL-0124-43' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.015835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58553091 LIMIT 5 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58553091 ORDER BY `minOrder` ASC [ RunTime:0.001120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58553091 ORDER BY `unit` DESC [ RunTime:0.002702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58553091 LIMIT 2 [ RunTime:0.009946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58553091 ORDER BY `minOrder` ASC [ RunTime:0.006578s ]
select * from pdf where partno='KL-0124-433' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.002520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-433' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001366s ]
SELECT `id` FROM `stock` WHERE `id` <> 58553091 AND `partno` = 'KL-0124-433' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186034 [ RunTime:0.005166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58552071 LIMIT 5 [ RunTime:0.002981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552071 ORDER BY `minOrder` ASC [ RunTime:0.006812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58552071 ORDER BY `unit` DESC [ RunTime:0.001162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58552071 LIMIT 2 [ RunTime:0.001403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552071 ORDER BY `minOrder` ASC [ RunTime:0.001863s ]
select * from pdf where partno='KL-0124-4358-10' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.003590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-10' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.007958s ]
SELECT `id` FROM `stock` WHERE `id` <> 58552071 AND `partno` = 'KL-0124-4358-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185200 [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58524983 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524983 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58524983 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58524983 LIMIT 2 [ RunTime:0.002878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524983 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='KL-0124-4311' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.006356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4311' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000717s ]
SELECT `id` FROM `stock` WHERE `id` <> 58524983 AND `partno` = 'KL-0124-4311' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58524968 LIMIT 5 [ RunTime:0.001921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524968 ORDER BY `minOrder` ASC [ RunTime:0.001024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58524968 ORDER BY `unit` DESC [ RunTime:0.005046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58524968 LIMIT 2 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58524968 ORDER BY `minOrder` ASC [ RunTime:0.004658s ]
select * from pdf where partno='KL-0124-432 K' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.006723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-432 K' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.003314s ]
SELECT `id` FROM `stock` WHERE `id` <> 58524968 AND `partno` = 'KL-0124-432 K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.005247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58523642 LIMIT 5 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58523642 ORDER BY `minOrder` ASC [ RunTime:0.015716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58523642 ORDER BY `unit` DESC [ RunTime:0.000871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58523642 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58523642 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='KL-0124-4331' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.003623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4331' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.003396s ]
SELECT `id` FROM `stock` WHERE `id` <> 58523642 AND `partno` = 'KL-0124-4331' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.005730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186386 [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58522030 LIMIT 5 [ RunTime:0.002156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58522030 ORDER BY `minOrder` ASC [ RunTime:0.002441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58522030 ORDER BY `unit` DESC [ RunTime:0.004902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58522030 LIMIT 2 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58522030 ORDER BY `minOrder` ASC [ RunTime:0.000602s ]
select * from pdf where partno='KL-0124-4331-1' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4331-1' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005554s ]
SELECT `id` FROM `stock` WHERE `id` <> 58522030 AND `partno` = 'KL-0124-4331-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.007866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58521068 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521068 ORDER BY `minOrder` ASC [ RunTime:0.002791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58521068 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58521068 LIMIT 2 [ RunTime:0.000394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58521068 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='KL-0124-4313' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.000634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4313' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 58521068 AND `partno` = 'KL-0124-4313' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12177014 [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58520127 LIMIT 5 [ RunTime:0.000536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520127 ORDER BY `minOrder` ASC [ RunTime:0.013235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58520127 ORDER BY `unit` DESC [ RunTime:0.006143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58520127 LIMIT 2 [ RunTime:0.007193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58520127 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='KL-0124-4358-1' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-1' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.007314s ]
SELECT `id` FROM `stock` WHERE `id` <> 58520127 AND `partno` = 'KL-0124-4358-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.016456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12176427 [ RunTime:0.002536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519862 LIMIT 5 [ RunTime:0.003987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519862 ORDER BY `minOrder` ASC [ RunTime:0.033434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519862 ORDER BY `unit` DESC [ RunTime:0.067559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519862 LIMIT 2 [ RunTime:0.002645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519862 ORDER BY `minOrder` ASC [ RunTime:0.057384s ]
select * from pdf where partno='KL-0124-4358-6' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.043364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-6' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.042421s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519862 AND `partno` = 'KL-0124-4358-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.090137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12176429 [ RunTime:0.018889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519534 LIMIT 5 [ RunTime:0.057639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519534 ORDER BY `minOrder` ASC [ RunTime:0.120855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519534 ORDER BY `unit` DESC [ RunTime:0.049324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519534 LIMIT 2 [ RunTime:0.038274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519534 ORDER BY `minOrder` ASC [ RunTime:0.022082s ]
select * from pdf where partno='KL-0124-4358-7' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.002833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-7' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.010296s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519534 AND `partno` = 'KL-0124-4358-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519526 LIMIT 5 [ RunTime:0.017462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519526 ORDER BY `minOrder` ASC [ RunTime:0.009330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519526 ORDER BY `unit` DESC [ RunTime:0.008643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519526 LIMIT 2 [ RunTime:0.009894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519526 ORDER BY `minOrder` ASC [ RunTime:0.016717s ]
select * from pdf where partno='KL-0124-4358-3' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.012667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-3' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.025662s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519526 AND `partno` = 'KL-0124-4358-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.017601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519520 LIMIT 5 [ RunTime:0.006426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519520 ORDER BY `minOrder` ASC [ RunTime:0.000838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519520 ORDER BY `unit` DESC [ RunTime:0.001358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519520 LIMIT 2 [ RunTime:0.009975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519520 ORDER BY `minOrder` ASC [ RunTime:0.006137s ]
select * from pdf where partno='KL-0124-4358-2' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.004410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-2' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.006002s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519520 AND `partno` = 'KL-0124-4358-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.007660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519519 LIMIT 5 [ RunTime:0.011456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519519 ORDER BY `minOrder` ASC [ RunTime:0.001337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519519 ORDER BY `unit` DESC [ RunTime:0.018116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519519 LIMIT 2 [ RunTime:0.005405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519519 ORDER BY `minOrder` ASC [ RunTime:0.011288s ]
select * from pdf where partno='KL-0124-4358-4' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.007795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-4' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.014016s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519519 AND `partno` = 'KL-0124-4358-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190074 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58519205 LIMIT 5 [ RunTime:0.004330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519205 ORDER BY `minOrder` ASC [ RunTime:0.008490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58519205 ORDER BY `unit` DESC [ RunTime:0.003027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58519205 LIMIT 2 [ RunTime:0.010530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58519205 ORDER BY `minOrder` ASC [ RunTime:0.007101s ]
select * from pdf where partno='KL-0124-4358-0' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-0' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005812s ]
SELECT `id` FROM `stock` WHERE `id` <> 58519205 AND `partno` = 'KL-0124-4358-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.006492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58518997 LIMIT 5 [ RunTime:0.002992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518997 ORDER BY `minOrder` ASC [ RunTime:0.013118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58518997 ORDER BY `unit` DESC [ RunTime:0.000723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58518997 LIMIT 2 [ RunTime:0.002505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518997 ORDER BY `minOrder` ASC [ RunTime:0.013081s ]
select * from pdf where partno='KL-0124-4358-5' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.002925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-5' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.002316s ]
SELECT `id` FROM `stock` WHERE `id` <> 58518997 AND `partno` = 'KL-0124-4358-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.004727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175947 [ RunTime:0.014724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58518988 LIMIT 5 [ RunTime:0.002719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518988 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58518988 ORDER BY `unit` DESC [ RunTime:0.001854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58518988 LIMIT 2 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518988 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='KL-0124-4358-9' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-9' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.002517s ]
SELECT `id` FROM `stock` WHERE `id` <> 58518988 AND `partno` = 'KL-0124-4358-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.002717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175773 [ RunTime:0.000938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58518986 LIMIT 5 [ RunTime:0.001685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518986 ORDER BY `minOrder` ASC [ RunTime:0.000703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58518986 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58518986 LIMIT 2 [ RunTime:0.003354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518986 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='KL-0124-4358-8' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.002412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4358-8' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000902s ]
SELECT `id` FROM `stock` WHERE `id` <> 58518986 AND `partno` = 'KL-0124-4358-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175945 [ RunTime:0.001300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58518671 LIMIT 5 [ RunTime:0.001781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518671 ORDER BY `minOrder` ASC [ RunTime:0.005339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58518671 ORDER BY `unit` DESC [ RunTime:0.001766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58518671 LIMIT 2 [ RunTime:0.013926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518671 ORDER BY `minOrder` ASC [ RunTime:0.005355s ]
select * from pdf where partno='KL-0124-4390' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4390' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005117s ]
SELECT `id` FROM `stock` WHERE `id` <> 58518671 AND `partno` = 'KL-0124-4390' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58518581 LIMIT 5 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518581 ORDER BY `minOrder` ASC [ RunTime:0.007754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58518581 ORDER BY `unit` DESC [ RunTime:0.003026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58518581 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58518581 ORDER BY `minOrder` ASC [ RunTime:0.003625s ]
select * from pdf where partno='KL-0124-4332' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.006099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KL-0124-4332' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001355s ]
SELECT `id` FROM `stock` WHERE `id` <> 58518581 AND `partno` = 'KL-0124-4332' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12175935 [ RunTime:0.000677s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001587s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002514s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001180s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005791s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036329s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023032s ]
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 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022767s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'KL-0124-43%' OR `brand` LIKE 'KL-0124-43%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033347s ]