SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001471s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037885s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17294070 LIMIT 5 [ RunTime:0.034794s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17294070 ORDER BY `minOrder` ASC [ RunTime:0.014080s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17294070 ORDER BY `unit` DESC [ RunTime:0.006494s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17294070 LIMIT 2 [ RunTime:0.041537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17294070 ORDER BY `minOrder` ASC [ RunTime:0.014679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19559152 LIMIT 5 [ RunTime:0.019475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559152 ORDER BY `minOrder` ASC [ RunTime:0.047184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19559152 ORDER BY `unit` DESC [ RunTime:0.079653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19559152 LIMIT 2 [ RunTime:0.076525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19559152 ORDER BY `minOrder` ASC [ RunTime:0.005367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19565666 LIMIT 5 [ RunTime:0.009662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19565666 ORDER BY `minOrder` ASC [ RunTime:0.015785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19565666 ORDER BY `unit` DESC [ RunTime:0.038583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19565666 LIMIT 2 [ RunTime:0.040053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19565666 ORDER BY `minOrder` ASC [ RunTime:0.048607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19565664 LIMIT 5 [ RunTime:0.012504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19565664 ORDER BY `minOrder` ASC [ RunTime:0.031200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19565664 ORDER BY `unit` DESC [ RunTime:0.033597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19565664 LIMIT 2 [ RunTime:0.035636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19565664 ORDER BY `minOrder` ASC [ RunTime:0.007820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19565662 LIMIT 5 [ RunTime:0.053359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19565662 ORDER BY `minOrder` ASC [ RunTime:0.046059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19565662 ORDER BY `unit` DESC [ RunTime:0.034313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19565662 LIMIT 2 [ RunTime:0.043604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19565662 ORDER BY `minOrder` ASC [ RunTime:0.023380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19554555 LIMIT 5 [ RunTime:0.039992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554555 ORDER BY `minOrder` ASC [ RunTime:0.027728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19554555 ORDER BY `unit` DESC [ RunTime:0.069778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19554555 LIMIT 2 [ RunTime:0.023367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554555 ORDER BY `minOrder` ASC [ RunTime:0.035807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19554554 LIMIT 5 [ RunTime:0.021288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554554 ORDER BY `minOrder` ASC [ RunTime:0.042613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19554554 ORDER BY `unit` DESC [ RunTime:0.021021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19554554 LIMIT 2 [ RunTime:0.013804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554554 ORDER BY `minOrder` ASC [ RunTime:0.003810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19554553 LIMIT 5 [ RunTime:0.007948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554553 ORDER BY `minOrder` ASC [ RunTime:0.007821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19554553 ORDER BY `unit` DESC [ RunTime:0.010498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19554553 LIMIT 2 [ RunTime:0.003910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554553 ORDER BY `minOrder` ASC [ RunTime:0.001055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19554552 LIMIT 5 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554552 ORDER BY `minOrder` ASC [ RunTime:0.010888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19554552 ORDER BY `unit` DESC [ RunTime:0.008166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19554552 LIMIT 2 [ RunTime:0.002348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19554552 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17293175 LIMIT 5 [ RunTime:0.001376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17293175 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17293175 ORDER BY `unit` DESC [ RunTime:0.008827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17293175 LIMIT 2 [ RunTime:0.002668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17293175 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17293173 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17293173 ORDER BY `minOrder` ASC [ RunTime:0.003056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17293173 ORDER BY `unit` DESC [ RunTime:0.003955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17293173 LIMIT 2 [ RunTime:0.001405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17293173 ORDER BY `minOrder` ASC [ RunTime:0.006748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15438126 LIMIT 5 [ RunTime:0.002068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15438126 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15438126 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15438126 LIMIT 2 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15438126 ORDER BY `minOrder` ASC [ RunTime:0.002951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15436539 LIMIT 5 [ RunTime:0.001012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15436539 ORDER BY `minOrder` ASC [ RunTime:0.005963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15436539 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15436539 LIMIT 2 [ RunTime:0.016868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15436539 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15436538 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15436538 ORDER BY `minOrder` ASC [ RunTime:0.005372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15436538 ORDER BY `unit` DESC [ RunTime:0.001185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15436538 LIMIT 2 [ RunTime:0.000717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15436538 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001339s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43782402 LIMIT 5 [ RunTime:0.004324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43782402 ORDER BY `minOrder` ASC [ RunTime:0.023573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43782402 ORDER BY `unit` DESC [ RunTime:0.020833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43782402 LIMIT 2 [ RunTime:0.019877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43782402 ORDER BY `minOrder` ASC [ RunTime:0.022790s ]
select * from pdf where partno='MN28TJW01-FA-1A' and brandshort='NKK Switches' limit 1 [ RunTime:0.041860s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FA-1A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.016445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43782403 LIMIT 5 [ RunTime:0.019249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43782403 ORDER BY `minOrder` ASC [ RunTime:0.019059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43782403 ORDER BY `unit` DESC [ RunTime:0.004806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43782403 LIMIT 2 [ RunTime:0.021466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43782403 ORDER BY `minOrder` ASC [ RunTime:0.002391s ]
select * from pdf where partno='MN28TJW01-GA-1A' and brandshort='NKK Switches' limit 1 [ RunTime:0.015202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-GA-1A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.030070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801792 LIMIT 5 [ RunTime:0.027469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801792 ORDER BY `minOrder` ASC [ RunTime:0.035202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801792 ORDER BY `unit` DESC [ RunTime:0.004039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801792 LIMIT 2 [ RunTime:0.020407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801792 ORDER BY `minOrder` ASC [ RunTime:0.019516s ]
select * from pdf where partno='MN28TJW01-GB-1A' and brandshort='NKK Switches' limit 1 [ RunTime:0.016138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-GB-1A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.007978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801785 LIMIT 5 [ RunTime:0.069277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801785 ORDER BY `minOrder` ASC [ RunTime:0.038128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801785 ORDER BY `unit` DESC [ RunTime:0.014500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801785 LIMIT 2 [ RunTime:0.009828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801785 ORDER BY `minOrder` ASC [ RunTime:0.002877s ]
select * from pdf where partno='MN28TJW01-FA-1B' and brandshort='NKK Switches' limit 1 [ RunTime:0.013077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FA-1B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.011316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801784 LIMIT 5 [ RunTime:0.017565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801784 ORDER BY `minOrder` ASC [ RunTime:0.014241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801784 ORDER BY `unit` DESC [ RunTime:0.007331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801784 LIMIT 2 [ RunTime:0.027197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801784 ORDER BY `minOrder` ASC [ RunTime:0.026500s ]
select * from pdf where partno='MN28TJW01-FH-1A' and brandshort='NKK Switches' limit 1 [ RunTime:0.026131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FH-1A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.022548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801782 LIMIT 5 [ RunTime:0.008185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801782 ORDER BY `minOrder` ASC [ RunTime:0.015431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801782 ORDER BY `unit` DESC [ RunTime:0.059745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801782 LIMIT 2 [ RunTime:0.101801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801782 ORDER BY `minOrder` ASC [ RunTime:0.014104s ]
select * from pdf where partno='MN28TJW01-FH-1H' and brandshort='NKK Switches' limit 1 [ RunTime:0.021793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FH-1H' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.029494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801781 LIMIT 5 [ RunTime:0.015861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801781 ORDER BY `minOrder` ASC [ RunTime:0.030073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801781 ORDER BY `unit` DESC [ RunTime:0.051642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801781 LIMIT 2 [ RunTime:0.032385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801781 ORDER BY `minOrder` ASC [ RunTime:0.033952s ]
select * from pdf where partno='MN28TJW01-GC-1A' and brandshort='NKK Switches' limit 1 [ RunTime:0.021611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-GC-1A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.033970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801780 LIMIT 5 [ RunTime:0.013443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801780 ORDER BY `minOrder` ASC [ RunTime:0.044390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801780 ORDER BY `unit` DESC [ RunTime:0.056169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801780 LIMIT 2 [ RunTime:0.071601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801780 ORDER BY `minOrder` ASC [ RunTime:0.073299s ]
select * from pdf where partno='MN28TJW01-FG-1B' and brandshort='NKK Switches' limit 1 [ RunTime:0.025040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FG-1B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.011436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801778 LIMIT 5 [ RunTime:0.050952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801778 ORDER BY `minOrder` ASC [ RunTime:0.017614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801778 ORDER BY `unit` DESC [ RunTime:0.017603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801778 LIMIT 2 [ RunTime:0.015125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801778 ORDER BY `minOrder` ASC [ RunTime:0.020542s ]
select * from pdf where partno='MN28TJW01-FB-1B' and brandshort='NKK Switches' limit 1 [ RunTime:0.008966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FB-1B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.029552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43801777 LIMIT 5 [ RunTime:0.027748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801777 ORDER BY `minOrder` ASC [ RunTime:0.022203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43801777 ORDER BY `unit` DESC [ RunTime:0.023741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43801777 LIMIT 2 [ RunTime:0.013250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43801777 ORDER BY `minOrder` ASC [ RunTime:0.027878s ]
select * from pdf where partno='MN28TJW01-FC-1A' and brandshort='NKK Switches' limit 1 [ RunTime:0.014652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FC-1A' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.031592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43797735 LIMIT 5 [ RunTime:0.036115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797735 ORDER BY `minOrder` ASC [ RunTime:0.010315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43797735 ORDER BY `unit` DESC [ RunTime:0.041022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43797735 LIMIT 2 [ RunTime:0.026833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797735 ORDER BY `minOrder` ASC [ RunTime:0.023063s ]
select * from pdf where partno='MN28TJW01-GB' and brandshort='NKK Switches' limit 1 [ RunTime:0.024453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-GB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.033391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43797733 LIMIT 5 [ RunTime:0.041112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797733 ORDER BY `minOrder` ASC [ RunTime:0.042768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43797733 ORDER BY `unit` DESC [ RunTime:0.076460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43797733 LIMIT 2 [ RunTime:0.034135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797733 ORDER BY `minOrder` ASC [ RunTime:0.041440s ]
select * from pdf where partno='MN28TJW01-GA' and brandshort='NKK Switches' limit 1 [ RunTime:0.035820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-GA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.063119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43797731 LIMIT 5 [ RunTime:0.014389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797731 ORDER BY `minOrder` ASC [ RunTime:0.081132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43797731 ORDER BY `unit` DESC [ RunTime:0.050987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43797731 LIMIT 2 [ RunTime:0.035199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797731 ORDER BY `minOrder` ASC [ RunTime:0.024226s ]
select * from pdf where partno='MN28TJW01-FA' and brandshort='NKK Switches' limit 1 [ RunTime:0.035802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01-FA' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.027703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43797649 LIMIT 5 [ RunTime:0.057742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797649 ORDER BY `minOrder` ASC [ RunTime:0.053648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43797649 ORDER BY `unit` DESC [ RunTime:0.152193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43797649 LIMIT 2 [ RunTime:0.103035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43797649 ORDER BY `minOrder` ASC [ RunTime:0.083319s ]
select * from pdf where partno='MN28TJW01' and brandshort='NKK Switches' limit 1 [ RunTime:0.083189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MN28TJW01' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.057466s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021560s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047265s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029681s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044468s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068829s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058353s ]
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 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051519s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MN28TJW01%' OR `brand` LIKE 'MN28TJW01%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022342s ]