SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002639s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014974s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512302 LIMIT 5 [ RunTime:0.022308s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512302 ORDER BY `minOrder` ASC [ RunTime:0.002045s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512302 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512302 LIMIT 2 [ RunTime:0.008002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512302 ORDER BY `minOrder` ASC [ RunTime:0.019089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346190 LIMIT 5 [ RunTime:0.015679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346190 ORDER BY `minOrder` ASC [ RunTime:0.014943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346190 ORDER BY `unit` DESC [ RunTime:0.012146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346190 LIMIT 2 [ RunTime:0.005054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346190 ORDER BY `minOrder` ASC [ RunTime:0.011494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252722 LIMIT 5 [ RunTime:0.014959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252722 ORDER BY `minOrder` ASC [ RunTime:0.017529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14252722 ORDER BY `unit` DESC [ RunTime:0.038093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14252722 LIMIT 2 [ RunTime:0.032446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14252722 ORDER BY `minOrder` ASC [ RunTime:0.070441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194427 LIMIT 5 [ RunTime:0.047709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194427 ORDER BY `minOrder` ASC [ RunTime:0.060868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194427 ORDER BY `unit` DESC [ RunTime:0.019223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194427 LIMIT 2 [ RunTime:0.009920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194427 ORDER BY `minOrder` ASC [ RunTime:0.001781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186291 LIMIT 5 [ RunTime:0.007958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186291 ORDER BY `minOrder` ASC [ RunTime:0.021835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186291 ORDER BY `unit` DESC [ RunTime:0.038868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186291 LIMIT 2 [ RunTime:0.033498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186291 ORDER BY `minOrder` ASC [ RunTime:0.032461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320632 LIMIT 5 [ RunTime:0.012138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320632 ORDER BY `minOrder` ASC [ RunTime:0.013941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13320632 ORDER BY `unit` DESC [ RunTime:0.010035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13320632 LIMIT 2 [ RunTime:0.031791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13320632 ORDER BY `minOrder` ASC [ RunTime:0.047294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512322 LIMIT 5 [ RunTime:0.027838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512322 ORDER BY `minOrder` ASC [ RunTime:0.034477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512322 ORDER BY `unit` DESC [ RunTime:0.106529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512322 LIMIT 2 [ RunTime:0.062262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512322 ORDER BY `minOrder` ASC [ RunTime:0.029722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512321 LIMIT 5 [ RunTime:0.051864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512321 ORDER BY `minOrder` ASC [ RunTime:0.016876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12512321 ORDER BY `unit` DESC [ RunTime:0.024025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12512321 LIMIT 2 [ RunTime:0.053297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12512321 ORDER BY `minOrder` ASC [ RunTime:0.003822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394644 LIMIT 5 [ RunTime:0.026106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394644 ORDER BY `minOrder` ASC [ RunTime:0.032161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12394644 ORDER BY `unit` DESC [ RunTime:0.002867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12394644 LIMIT 2 [ RunTime:0.008118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12394644 ORDER BY `minOrder` ASC [ RunTime:0.009985s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281760 LIMIT 5 [ RunTime:0.006738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281760 ORDER BY `minOrder` ASC [ RunTime:0.015981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281760 ORDER BY `unit` DESC [ RunTime:0.001105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281760 LIMIT 2 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281760 ORDER BY `minOrder` ASC [ RunTime:0.002588s ]
select * from pdf where partno='31945' and brandshort='te connectivity' limit 1 [ RunTime:0.003731s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003068s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31945' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.023545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281601 LIMIT 5 [ RunTime:0.004373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281601 ORDER BY `minOrder` ASC [ RunTime:0.004791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281601 ORDER BY `unit` DESC [ RunTime:0.002867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281601 LIMIT 2 [ RunTime:0.010586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281601 ORDER BY `minOrder` ASC [ RunTime:0.000510s ]
select * from pdf where partno='31945' and brandshort='te connectivity' limit 1 [ RunTime:0.000844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31945' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.000590s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54116943 LIMIT 5 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116943 ORDER BY `minOrder` ASC [ RunTime:0.020679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54116943 ORDER BY `unit` DESC [ RunTime:0.004201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54116943 LIMIT 2 [ RunTime:0.004812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116943 ORDER BY `minOrder` ASC [ RunTime:0.004229s ]
select * from pdf where partno='31943' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31943' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.010825s ]
SELECT `id` FROM `stock` WHERE `id` <> 54116943 AND `partno` = '31943' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512302 [ RunTime:0.000529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50743730 LIMIT 5 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743730 ORDER BY `minOrder` ASC [ RunTime:0.000911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50743730 ORDER BY `unit` DESC [ RunTime:0.000473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50743730 LIMIT 2 [ RunTime:0.006266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50743730 ORDER BY `minOrder` ASC [ RunTime:0.023713s ]
select * from pdf where partno='3194CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.033463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3194CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.037789s ]
SELECT `id` FROM `stock` WHERE `id` <> 50743730 AND `partno` = '3194CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.017926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346190 [ RunTime:0.084560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147519 LIMIT 5 [ RunTime:0.052250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147519 ORDER BY `minOrder` ASC [ RunTime:0.010488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147519 ORDER BY `unit` DESC [ RunTime:0.004179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147519 LIMIT 2 [ RunTime:0.013453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147519 ORDER BY `minOrder` ASC [ RunTime:0.011413s ]
select * from pdf where partno='3194CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3194CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003909s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147519 AND `partno` = '3194CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.017629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346190 [ RunTime:0.018332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37679537 LIMIT 5 [ RunTime:0.009741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37679537 ORDER BY `minOrder` ASC [ RunTime:0.010084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37679537 ORDER BY `unit` DESC [ RunTime:0.002534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37679537 LIMIT 2 [ RunTime:0.003265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37679537 ORDER BY `minOrder` ASC [ RunTime:0.002237s ]
select * from pdf where partno='31943' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.003523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31943' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.005363s ]
SELECT `id` FROM `stock` WHERE `id` <> 37679537 AND `partno` = '31943' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.022146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252722 [ RunTime:0.017027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50482149 LIMIT 5 [ RunTime:0.020577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50482149 ORDER BY `minOrder` ASC [ RunTime:0.032415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50482149 ORDER BY `unit` DESC [ RunTime:0.026977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50482149 LIMIT 2 [ RunTime:0.011805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50482149 ORDER BY `minOrder` ASC [ RunTime:0.006398s ]
select * from pdf where partno='31943' and brandshort='Vicor Corporation' limit 1 [ RunTime:0.003759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31943' OR `brand` LIKE 'Vicor Corporation%' ) ) LIMIT 1 [ RunTime:0.006551s ]
SELECT `id` FROM `stock` WHERE `id` <> 50482149 AND `partno` = '31943' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vicor corporation%' ) [ RunTime:0.006534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14252722 [ RunTime:0.019883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56551531 LIMIT 5 [ RunTime:0.029901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56551531 ORDER BY `minOrder` ASC [ RunTime:0.044112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56551531 ORDER BY `unit` DESC [ RunTime:0.007823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56551531 LIMIT 2 [ RunTime:0.005140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56551531 ORDER BY `minOrder` ASC [ RunTime:0.007680s ]
select * from pdf where partno='3194' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3194' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000314s ]
SELECT `id` FROM `stock` WHERE `id` <> 56551531 AND `partno` = '3194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.004791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320632 [ RunTime:0.020978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54116980 LIMIT 5 [ RunTime:0.025799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116980 ORDER BY `minOrder` ASC [ RunTime:0.030994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54116980 ORDER BY `unit` DESC [ RunTime:0.023473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54116980 LIMIT 2 [ RunTime:0.023562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116980 ORDER BY `minOrder` ASC [ RunTime:0.013834s ]
select * from pdf where partno='31942' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.033446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31942' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.097112s ]
SELECT `id` FROM `stock` WHERE `id` <> 54116980 AND `partno` = '31942' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.060374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512322 [ RunTime:0.033767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54116979 LIMIT 5 [ RunTime:0.022642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116979 ORDER BY `minOrder` ASC [ RunTime:0.035249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54116979 ORDER BY `unit` DESC [ RunTime:0.049971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54116979 LIMIT 2 [ RunTime:0.004223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54116979 ORDER BY `minOrder` ASC [ RunTime:0.012176s ]
select * from pdf where partno='31945' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31945' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.027087s ]
SELECT `id` FROM `stock` WHERE `id` <> 54116979 AND `partno` = '31945' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12512321 [ RunTime:0.007425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50243700 LIMIT 5 [ RunTime:0.011028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50243700 ORDER BY `minOrder` ASC [ RunTime:0.029478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50243700 ORDER BY `unit` DESC [ RunTime:0.009799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50243700 LIMIT 2 [ RunTime:0.016981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50243700 ORDER BY `minOrder` ASC [ RunTime:0.005298s ]
select * from pdf where partno='3194' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3194' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000613s ]
SELECT `id` FROM `stock` WHERE `id` <> 50243700 AND `partno` = '3194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394644 [ RunTime:0.003046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37440761 LIMIT 5 [ RunTime:0.004032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37440761 ORDER BY `minOrder` ASC [ RunTime:0.002447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37440761 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37440761 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37440761 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='3194' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.008602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3194' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.004988s ]
SELECT `id` FROM `stock` WHERE `id` <> 37440761 AND `partno` = '3194' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.019712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12394644 [ RunTime:0.000470s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002134s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005163s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002590s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014528s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003149s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003336s ]
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 '3194%' OR `brand` LIKE '3194%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003273s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3194%' OR `brand` LIKE '3194%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001171s ]