SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001460s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033959s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12256782 LIMIT 5 [ RunTime:0.158518s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.059428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12256782 ORDER BY `minOrder` ASC [ RunTime:0.099203s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12256782 ORDER BY `unit` DESC [ RunTime:0.059232s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12256782 LIMIT 2 [ RunTime:0.050889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12256782 ORDER BY `minOrder` ASC [ RunTime:0.045512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11248429 LIMIT 5 [ RunTime:0.125816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11248429 ORDER BY `minOrder` ASC [ RunTime:0.111734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11248429 ORDER BY `unit` DESC [ RunTime:0.122795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11248429 LIMIT 2 [ RunTime:0.181692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11248429 ORDER BY `minOrder` ASC [ RunTime:0.151945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11247006 LIMIT 5 [ RunTime:0.277376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11247006 ORDER BY `minOrder` ASC [ RunTime:0.187506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11247006 ORDER BY `unit` DESC [ RunTime:0.110999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11247006 LIMIT 2 [ RunTime:0.076063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11247006 ORDER BY `minOrder` ASC [ RunTime:0.131144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11246855 LIMIT 5 [ RunTime:0.127208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11246855 ORDER BY `minOrder` ASC [ RunTime:0.094797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11246855 ORDER BY `unit` DESC [ RunTime:0.183645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11246855 LIMIT 2 [ RunTime:0.088367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11246855 ORDER BY `minOrder` ASC [ RunTime:0.006096s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058117s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.130411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63772695 LIMIT 5 [ RunTime:0.023417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63772695 ORDER BY `minOrder` ASC [ RunTime:0.109543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63772695 ORDER BY `unit` DESC [ RunTime:0.021593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63772695 LIMIT 2 [ RunTime:0.081568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63772695 ORDER BY `minOrder` ASC [ RunTime:0.006499s ]
select * from pdf where partno='TLV5619QDWREP' and brandshort='Texas Instruments' limit 1 [ RunTime:0.043149s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLV5619QDWREP' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.090636s ]
SELECT `id` FROM `stock` WHERE `id` <> 63772695 AND `partno` = 'TLV5619QDWREP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.096191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12256782 [ RunTime:0.036067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63770852 LIMIT 5 [ RunTime:0.087852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63770852 ORDER BY `minOrder` ASC [ RunTime:0.066293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63770852 ORDER BY `unit` DESC [ RunTime:0.012574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63770852 LIMIT 2 [ RunTime:0.012010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63770852 ORDER BY `minOrder` ASC [ RunTime:0.039422s ]
select * from pdf where partno='TLV5619QDWR' and brandshort='Texas Instruments' limit 1 [ RunTime:0.045509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLV5619QDWR' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.053381s ]
SELECT `id` FROM `stock` WHERE `id` <> 63770852 AND `partno` = 'TLV5619QDWR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.015058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11248429 [ RunTime:0.030158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63768390 LIMIT 5 [ RunTime:0.041661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768390 ORDER BY `minOrder` ASC [ RunTime:0.084930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63768390 ORDER BY `unit` DESC [ RunTime:0.127272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63768390 LIMIT 2 [ RunTime:0.226528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768390 ORDER BY `minOrder` ASC [ RunTime:0.058441s ]
select * from pdf where partno='TLV5619QDWG4' and brandshort='Texas Instruments' limit 1 [ RunTime:0.069443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLV5619QDWG4' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.119877s ]
SELECT `id` FROM `stock` WHERE `id` <> 63768390 AND `partno` = 'TLV5619QDWG4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.209991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11247006 [ RunTime:0.097705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63768259 LIMIT 5 [ RunTime:0.109114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768259 ORDER BY `minOrder` ASC [ RunTime:0.060719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63768259 ORDER BY `unit` DESC [ RunTime:0.056800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63768259 LIMIT 2 [ RunTime:0.025760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63768259 ORDER BY `minOrder` ASC [ RunTime:0.009573s ]
select * from pdf where partno='TLV5619QDW' and brandshort='Texas Instruments' limit 1 [ RunTime:0.028758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLV5619QDW' OR `brand` LIKE 'Texas Instruments%' ) ) LIMIT 1 [ RunTime:0.002492s ]
SELECT `id` FROM `stock` WHERE `id` <> 63768259 AND `partno` = 'TLV5619QDW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.047420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11246855 [ RunTime:0.048193s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079526s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.199851s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087926s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.143347s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.147156s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051390s ]
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 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043672s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TLV5619QDW%' OR `brand` LIKE 'TLV5619QDW%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.052914s ]