SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001353s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034190s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394463 LIMIT 5 [ RunTime:0.006100s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394463 ORDER BY `minOrder` ASC [ RunTime:0.011563s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394463 ORDER BY `unit` DESC [ RunTime:0.010937s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394463 LIMIT 2 [ RunTime:0.008282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394463 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394462 LIMIT 5 [ RunTime:0.004518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394462 ORDER BY `minOrder` ASC [ RunTime:0.016868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394462 ORDER BY `unit` DESC [ RunTime:0.016090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394462 LIMIT 2 [ RunTime:0.052132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394462 ORDER BY `minOrder` ASC [ RunTime:0.015234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394461 LIMIT 5 [ RunTime:0.024071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394461 ORDER BY `minOrder` ASC [ RunTime:0.033552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394461 ORDER BY `unit` DESC [ RunTime:0.021770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394461 LIMIT 2 [ RunTime:0.016019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394461 ORDER BY `minOrder` ASC [ RunTime:0.008105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394459 LIMIT 5 [ RunTime:0.016606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394459 ORDER BY `minOrder` ASC [ RunTime:0.040006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394459 ORDER BY `unit` DESC [ RunTime:0.010015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394459 LIMIT 2 [ RunTime:0.006481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394459 ORDER BY `minOrder` ASC [ RunTime:0.014445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394457 LIMIT 5 [ RunTime:0.003656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394457 ORDER BY `minOrder` ASC [ RunTime:0.019957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394457 ORDER BY `unit` DESC [ RunTime:0.006566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394457 LIMIT 2 [ RunTime:0.012558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394457 ORDER BY `minOrder` ASC [ RunTime:0.012355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394455 LIMIT 5 [ RunTime:0.007537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394455 ORDER BY `minOrder` ASC [ RunTime:0.006061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394455 ORDER BY `unit` DESC [ RunTime:0.018124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394455 LIMIT 2 [ RunTime:0.032519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394455 ORDER BY `minOrder` ASC [ RunTime:0.004905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394454 LIMIT 5 [ RunTime:0.013385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394454 ORDER BY `minOrder` ASC [ RunTime:0.031481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394454 ORDER BY `unit` DESC [ RunTime:0.006988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394454 LIMIT 2 [ RunTime:0.026895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394454 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394453 LIMIT 5 [ RunTime:0.004870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394453 ORDER BY `minOrder` ASC [ RunTime:0.012801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394453 ORDER BY `unit` DESC [ RunTime:0.011130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394453 LIMIT 2 [ RunTime:0.030991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394453 ORDER BY `minOrder` ASC [ RunTime:0.011150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394452 LIMIT 5 [ RunTime:0.016502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394452 ORDER BY `minOrder` ASC [ RunTime:0.024613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394452 ORDER BY `unit` DESC [ RunTime:0.014692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394452 LIMIT 2 [ RunTime:0.033052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394452 ORDER BY `minOrder` ASC [ RunTime:0.018451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394451 LIMIT 5 [ RunTime:0.007171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394451 ORDER BY `minOrder` ASC [ RunTime:0.010232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394451 ORDER BY `unit` DESC [ RunTime:0.022802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394451 LIMIT 2 [ RunTime:0.019712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394451 ORDER BY `minOrder` ASC [ RunTime:0.006892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394450 LIMIT 5 [ RunTime:0.022229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394450 ORDER BY `minOrder` ASC [ RunTime:0.029120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394450 ORDER BY `unit` DESC [ RunTime:0.013620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394450 LIMIT 2 [ RunTime:0.042391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394450 ORDER BY `minOrder` ASC [ RunTime:0.004643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394449 LIMIT 5 [ RunTime:0.015691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394449 ORDER BY `minOrder` ASC [ RunTime:0.047456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394449 ORDER BY `unit` DESC [ RunTime:0.021566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394449 LIMIT 2 [ RunTime:0.016862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394449 ORDER BY `minOrder` ASC [ RunTime:0.027096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394448 LIMIT 5 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394448 ORDER BY `minOrder` ASC [ RunTime:0.020443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394448 ORDER BY `unit` DESC [ RunTime:0.016082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394448 LIMIT 2 [ RunTime:0.012039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394448 ORDER BY `minOrder` ASC [ RunTime:0.020781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394447 LIMIT 5 [ RunTime:0.024355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394447 ORDER BY `minOrder` ASC [ RunTime:0.036143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14394447 ORDER BY `unit` DESC [ RunTime:0.023770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14394447 LIMIT 2 [ RunTime:0.003416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14394447 ORDER BY `minOrder` ASC [ RunTime:0.036917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522727 LIMIT 5 [ RunTime:0.063082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522727 ORDER BY `minOrder` ASC [ RunTime:0.020389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522727 ORDER BY `unit` DESC [ RunTime:0.016065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522727 LIMIT 2 [ RunTime:0.023343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522727 ORDER BY `minOrder` ASC [ RunTime:0.031340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522726 LIMIT 5 [ RunTime:0.020836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522726 ORDER BY `minOrder` ASC [ RunTime:0.039271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522726 ORDER BY `unit` DESC [ RunTime:0.022905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522726 LIMIT 2 [ RunTime:0.026800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522726 ORDER BY `minOrder` ASC [ RunTime:0.007256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522725 LIMIT 5 [ RunTime:0.036011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522725 ORDER BY `minOrder` ASC [ RunTime:0.024926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522725 ORDER BY `unit` DESC [ RunTime:0.012216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522725 LIMIT 2 [ RunTime:0.014136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522725 ORDER BY `minOrder` ASC [ RunTime:0.003502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522724 LIMIT 5 [ RunTime:0.007981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522724 ORDER BY `minOrder` ASC [ RunTime:0.012368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522724 ORDER BY `unit` DESC [ RunTime:0.006388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522724 LIMIT 2 [ RunTime:0.011270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522724 ORDER BY `minOrder` ASC [ RunTime:0.032503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522722 LIMIT 5 [ RunTime:0.025772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522722 ORDER BY `minOrder` ASC [ RunTime:0.049750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522722 ORDER BY `unit` DESC [ RunTime:0.027054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522722 LIMIT 2 [ RunTime:0.018784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522722 ORDER BY `minOrder` ASC [ RunTime:0.002050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522720 LIMIT 5 [ RunTime:0.029975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522720 ORDER BY `minOrder` ASC [ RunTime:0.006453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13522720 ORDER BY `unit` DESC [ RunTime:0.033936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13522720 LIMIT 2 [ RunTime:0.028610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13522720 ORDER BY `minOrder` ASC [ RunTime:0.008450s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028967s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695474 LIMIT 5 [ RunTime:0.012163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695474 ORDER BY `minOrder` ASC [ RunTime:0.023013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695474 ORDER BY `unit` DESC [ RunTime:0.039783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695474 LIMIT 2 [ RunTime:0.036951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695474 ORDER BY `minOrder` ASC [ RunTime:0.006106s ]
select * from pdf where partno='5110P-1' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008065s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-1' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007857s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695474 AND `partno` = '5110P-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.020639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522727 [ RunTime:0.011370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695473 LIMIT 5 [ RunTime:0.032471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695473 ORDER BY `minOrder` ASC [ RunTime:0.009744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695473 ORDER BY `unit` DESC [ RunTime:0.025241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695473 LIMIT 2 [ RunTime:0.054175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695473 ORDER BY `minOrder` ASC [ RunTime:0.044018s ]
select * from pdf where partno='5110P-5' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-5' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027328s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695473 AND `partno` = '5110P-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.042424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522726 [ RunTime:0.025257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695472 LIMIT 5 [ RunTime:0.030027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695472 ORDER BY `minOrder` ASC [ RunTime:0.012941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695472 ORDER BY `unit` DESC [ RunTime:0.039616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695472 LIMIT 2 [ RunTime:0.042017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695472 ORDER BY `minOrder` ASC [ RunTime:0.031601s ]
select * from pdf where partno='5110P-M' and brandshort='Brady Corporation' limit 1 [ RunTime:0.056128s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-M' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.039361s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695472 AND `partno` = '5110P-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.029644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522725 [ RunTime:0.081843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695471 LIMIT 5 [ RunTime:0.065846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695471 ORDER BY `minOrder` ASC [ RunTime:0.032483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695471 ORDER BY `unit` DESC [ RunTime:0.023828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695471 LIMIT 2 [ RunTime:0.017283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695471 ORDER BY `minOrder` ASC [ RunTime:0.013214s ]
select * from pdf where partno='5110P-$' and brandshort='Brady Corporation' limit 1 [ RunTime:0.013874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-$' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.059804s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695471 AND `partno` = '5110P-$' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.047282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522724 [ RunTime:0.011704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695469 LIMIT 5 [ RunTime:0.030726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695469 ORDER BY `minOrder` ASC [ RunTime:0.020200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695469 ORDER BY `unit` DESC [ RunTime:0.039376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695469 LIMIT 2 [ RunTime:0.034888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695469 ORDER BY `minOrder` ASC [ RunTime:0.018984s ]
select * from pdf where partno='5110P-T' and brandshort='Brady Corporation' limit 1 [ RunTime:0.026343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-T' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.025392s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695469 AND `partno` = '5110P-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522722 [ RunTime:0.008932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695467 LIMIT 5 [ RunTime:0.022694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695467 ORDER BY `minOrder` ASC [ RunTime:0.001914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695467 ORDER BY `unit` DESC [ RunTime:0.000385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695467 LIMIT 2 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695467 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='5110P-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.023900s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695467 AND `partno` = '5110P-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522720 [ RunTime:0.010956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695466 LIMIT 5 [ RunTime:0.042455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695466 ORDER BY `minOrder` ASC [ RunTime:0.036162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695466 ORDER BY `unit` DESC [ RunTime:0.031690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695466 LIMIT 2 [ RunTime:0.015474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695466 ORDER BY `minOrder` ASC [ RunTime:0.024563s ]
select * from pdf where partno='5110P-U' and brandshort='Brady Corporation' limit 1 [ RunTime:0.019037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-U' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022822s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695466 AND `partno` = '5110P-U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522719 [ RunTime:0.051761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695465 LIMIT 5 [ RunTime:0.024270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695465 ORDER BY `minOrder` ASC [ RunTime:0.043414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695465 ORDER BY `unit` DESC [ RunTime:0.020903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695465 LIMIT 2 [ RunTime:0.014001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695465 ORDER BY `minOrder` ASC [ RunTime:0.014038s ]
select * from pdf where partno='5110P-P' and brandshort='Brady Corporation' limit 1 [ RunTime:0.015239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-P' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022492s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695465 AND `partno` = '5110P-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.033542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522718 [ RunTime:0.019949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695463 LIMIT 5 [ RunTime:0.012827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695463 ORDER BY `minOrder` ASC [ RunTime:0.041397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695463 ORDER BY `unit` DESC [ RunTime:0.058920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695463 LIMIT 2 [ RunTime:0.050082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695463 ORDER BY `minOrder` ASC [ RunTime:0.028415s ]
select * from pdf where partno='5110P-ARO' and brandshort='Brady Corporation' limit 1 [ RunTime:0.021110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-ARO' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017842s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695463 AND `partno` = '5110P-ARO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522716 [ RunTime:0.048901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695462 LIMIT 5 [ RunTime:0.035684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695462 ORDER BY `minOrder` ASC [ RunTime:0.059206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695462 ORDER BY `unit` DESC [ RunTime:0.037292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695462 LIMIT 2 [ RunTime:0.029008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695462 ORDER BY `minOrder` ASC [ RunTime:0.030082s ]
select * from pdf where partno='5110P-&' and brandshort='Brady Corporation' limit 1 [ RunTime:0.020860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-&' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.026501s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695462 AND `partno` = '5110P-&' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.025491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394463 [ RunTime:0.050697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695461 LIMIT 5 [ RunTime:0.069488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695461 ORDER BY `minOrder` ASC [ RunTime:0.037413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695461 ORDER BY `unit` DESC [ RunTime:0.012732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695461 LIMIT 2 [ RunTime:0.005248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695461 ORDER BY `minOrder` ASC [ RunTime:0.008561s ]
select * from pdf where partno='5110P-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.019320s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695461 AND `partno` = '5110P-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.029769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394462 [ RunTime:0.011835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695460 LIMIT 5 [ RunTime:0.014042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695460 ORDER BY `minOrder` ASC [ RunTime:0.027544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695460 ORDER BY `unit` DESC [ RunTime:0.017313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695460 LIMIT 2 [ RunTime:0.042636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695460 ORDER BY `minOrder` ASC [ RunTime:0.016685s ]
select * from pdf where partno='5110P-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.023241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.052599s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695460 AND `partno` = '5110P-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.056626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394461 [ RunTime:0.028274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695458 LIMIT 5 [ RunTime:0.039734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695458 ORDER BY `minOrder` ASC [ RunTime:0.024369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695458 ORDER BY `unit` DESC [ RunTime:0.063921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695458 LIMIT 2 [ RunTime:0.016479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695458 ORDER BY `minOrder` ASC [ RunTime:0.012962s ]
select * from pdf where partno='5110P-0' and brandshort='Brady Corporation' limit 1 [ RunTime:0.009373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-0' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020369s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695458 AND `partno` = '5110P-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.058158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394459 [ RunTime:0.028222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695456 LIMIT 5 [ RunTime:0.030728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695456 ORDER BY `minOrder` ASC [ RunTime:0.028423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695456 ORDER BY `unit` DESC [ RunTime:0.028374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695456 LIMIT 2 [ RunTime:0.028471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695456 ORDER BY `minOrder` ASC [ RunTime:0.032431s ]
select * from pdf where partno='5110P-S' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-S' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021521s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695456 AND `partno` = '5110P-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.061659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14394457 [ RunTime:0.025331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695454 LIMIT 5 [ RunTime:0.044800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695454 ORDER BY `minOrder` ASC [ RunTime:0.032680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695454 ORDER BY `unit` DESC [ RunTime:0.021889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695454 LIMIT 2 [ RunTime:0.012768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695454 ORDER BY `minOrder` ASC [ RunTime:0.007952s ]
select * from pdf where partno='5110P-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.038979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.031414s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695454 AND `partno` = '5110P-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.043760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522715 [ RunTime:0.034918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695453 LIMIT 5 [ RunTime:0.055719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695453 ORDER BY `minOrder` ASC [ RunTime:0.014537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695453 ORDER BY `unit` DESC [ RunTime:0.035007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695453 LIMIT 2 [ RunTime:0.017008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695453 ORDER BY `minOrder` ASC [ RunTime:0.008186s ]
select * from pdf where partno='5110P-PUN' and brandshort='Brady Corporation' limit 1 [ RunTime:0.019961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-PUN' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021072s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695453 AND `partno` = '5110P-PUN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.031533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522714 [ RunTime:0.044318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695452 LIMIT 5 [ RunTime:0.031513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695452 ORDER BY `minOrder` ASC [ RunTime:0.009560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695452 ORDER BY `unit` DESC [ RunTime:0.010911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695452 LIMIT 2 [ RunTime:0.013334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695452 ORDER BY `minOrder` ASC [ RunTime:0.013780s ]
select * from pdf where partno='5110P-L' and brandshort='Brady Corporation' limit 1 [ RunTime:0.013715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-L' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010208s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695452 AND `partno` = '5110P-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.026151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522713 [ RunTime:0.019562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695451 LIMIT 5 [ RunTime:0.005851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695451 ORDER BY `minOrder` ASC [ RunTime:0.001941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695451 ORDER BY `unit` DESC [ RunTime:0.002581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695451 LIMIT 2 [ RunTime:0.022425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695451 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
select * from pdf where partno='5110P-K' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-K' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011990s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695451 AND `partno` = '5110P-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522712 [ RunTime:0.006482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695450 LIMIT 5 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695450 ORDER BY `minOrder` ASC [ RunTime:0.000649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695450 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695450 LIMIT 2 [ RunTime:0.001377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695450 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='5110P-Y' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-Y' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.003084s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695450 AND `partno` = '5110P-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.010426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522711 [ RunTime:0.011856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57695448 LIMIT 5 [ RunTime:0.011582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695448 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57695448 ORDER BY `unit` DESC [ RunTime:0.000580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57695448 LIMIT 2 [ RunTime:0.008477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57695448 ORDER BY `minOrder` ASC [ RunTime:0.010299s ]
select * from pdf where partno='5110P-V' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5110P-V' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004295s ]
SELECT `id` FROM `stock` WHERE `id` <> 57695448 AND `partno` = '5110P-V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13522709 [ RunTime:0.003222s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005900s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001006s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000927s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002725s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002817s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003965s ]
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 '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003205s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5110P-%' OR `brand` LIKE '5110P-%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014935s ]