SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001784s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007224s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19823283 LIMIT 5 [ RunTime:0.019706s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.010755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19823283 ORDER BY `minOrder` ASC [ RunTime:0.025126s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19823283 ORDER BY `unit` DESC [ RunTime:0.032365s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.047843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19823283 LIMIT 2 [ RunTime:0.057979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19823283 ORDER BY `minOrder` ASC [ RunTime:0.017291s ]
select * from pdf where partno='TSW-109-07-S-S-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.051586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19822379 LIMIT 5 [ RunTime:0.049654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19822379 ORDER BY `minOrder` ASC [ RunTime:0.085860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19822379 ORDER BY `unit` DESC [ RunTime:0.050299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19822379 LIMIT 2 [ RunTime:0.030065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19822379 ORDER BY `minOrder` ASC [ RunTime:0.051261s ]
select * from pdf where partno='TSW-109-07-S-S-LL-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.122459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19780108 LIMIT 5 [ RunTime:0.031296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19780108 ORDER BY `minOrder` ASC [ RunTime:0.029255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19780108 ORDER BY `unit` DESC [ RunTime:0.034829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19780108 LIMIT 2 [ RunTime:0.034516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19780108 ORDER BY `minOrder` ASC [ RunTime:0.063536s ]
select * from pdf where partno='TSW-109-07-S-S-LL-003' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.067989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182863 LIMIT 5 [ RunTime:0.053001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182863 ORDER BY `minOrder` ASC [ RunTime:0.000853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182863 ORDER BY `unit` DESC [ RunTime:0.124010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182863 LIMIT 2 [ RunTime:0.092578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182863 ORDER BY `minOrder` ASC [ RunTime:0.011488s ]
select * from pdf where partno='TSW-109-07-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.053280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15479715 LIMIT 5 [ RunTime:0.069609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15479715 ORDER BY `minOrder` ASC [ RunTime:0.052751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15479715 ORDER BY `unit` DESC [ RunTime:0.036760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15479715 LIMIT 2 [ RunTime:0.060607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15479715 ORDER BY `minOrder` ASC [ RunTime:0.046926s ]
select * from pdf where partno='TSW-109-07-S-S-003' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478645 LIMIT 5 [ RunTime:0.149086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478645 ORDER BY `minOrder` ASC [ RunTime:0.082677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478645 ORDER BY `unit` DESC [ RunTime:0.016465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478645 LIMIT 2 [ RunTime:0.036458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478645 ORDER BY `minOrder` ASC [ RunTime:0.030149s ]
select * from pdf where partno='TSW-109-07-S-S-004' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478644 LIMIT 5 [ RunTime:0.048088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478644 ORDER BY `minOrder` ASC [ RunTime:0.036679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478644 ORDER BY `unit` DESC [ RunTime:0.051900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478644 LIMIT 2 [ RunTime:0.045243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478644 ORDER BY `minOrder` ASC [ RunTime:0.061753s ]
select * from pdf where partno='TSW-109-07-S-S-001' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.040990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11564942 LIMIT 5 [ RunTime:0.029282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11564942 ORDER BY `minOrder` ASC [ RunTime:0.027717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11564942 ORDER BY `unit` DESC [ RunTime:0.016739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11564942 LIMIT 2 [ RunTime:0.010648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11564942 ORDER BY `minOrder` ASC [ RunTime:0.001701s ]
select * from pdf where partno='TSW-109-07-S-S-LL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014328s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024304s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59550672 LIMIT 5 [ RunTime:0.022768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59550672 ORDER BY `minOrder` ASC [ RunTime:0.014214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59550672 ORDER BY `unit` DESC [ RunTime:0.055596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59550672 LIMIT 2 [ RunTime:0.036215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59550672 ORDER BY `minOrder` ASC [ RunTime:0.017643s ]
select * from pdf where partno='TSW-109-07-S-S-003' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013694s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-003' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043430s ]
SELECT `id` FROM `stock` WHERE `id` <> 59550672 AND `partno` = 'TSW-109-07-S-S-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.083512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15479715 [ RunTime:0.045302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59550290 LIMIT 5 [ RunTime:0.066105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59550290 ORDER BY `minOrder` ASC [ RunTime:0.081432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59550290 ORDER BY `unit` DESC [ RunTime:0.061255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59550290 LIMIT 2 [ RunTime:0.070777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59550290 ORDER BY `minOrder` ASC [ RunTime:0.009043s ]
select * from pdf where partno='TSW-109-07-S-S-LL-003' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-LL-003' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018571s ]
SELECT `id` FROM `stock` WHERE `id` <> 59550290 AND `partno` = 'TSW-109-07-S-S-LL-003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.049266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19780108 [ RunTime:0.078348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59549922 LIMIT 5 [ RunTime:0.005336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549922 ORDER BY `minOrder` ASC [ RunTime:0.041190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59549922 ORDER BY `unit` DESC [ RunTime:0.031180s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59549922 LIMIT 2 [ RunTime:0.050582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549922 ORDER BY `minOrder` ASC [ RunTime:0.030034s ]
select * from pdf where partno='TSW-109-07-S-S-001' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-001' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.110499s ]
SELECT `id` FROM `stock` WHERE `id` <> 59549922 AND `partno` = 'TSW-109-07-S-S-001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.085576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478644 [ RunTime:0.059767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59549921 LIMIT 5 [ RunTime:0.034625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549921 ORDER BY `minOrder` ASC [ RunTime:0.071654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59549921 ORDER BY `unit` DESC [ RunTime:0.067496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59549921 LIMIT 2 [ RunTime:0.040027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59549921 ORDER BY `minOrder` ASC [ RunTime:0.019356s ]
select * from pdf where partno='TSW-109-07-S-S-004' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.051442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-004' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033064s ]
SELECT `id` FROM `stock` WHERE `id` <> 59549921 AND `partno` = 'TSW-109-07-S-S-004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.080779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478645 [ RunTime:0.086821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59548861 LIMIT 5 [ RunTime:0.056479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59548861 ORDER BY `minOrder` ASC [ RunTime:0.068406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59548861 ORDER BY `unit` DESC [ RunTime:0.047044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59548861 LIMIT 2 [ RunTime:0.056058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59548861 ORDER BY `minOrder` ASC [ RunTime:0.012879s ]
select * from pdf where partno='TSW-109-07-S-S-LL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-LL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.141416s ]
SELECT `id` FROM `stock` WHERE `id` <> 59548861 AND `partno` = 'TSW-109-07-S-S-LL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11564942 [ RunTime:0.110050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59543833 LIMIT 5 [ RunTime:0.062190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59543833 ORDER BY `minOrder` ASC [ RunTime:0.034147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59543833 ORDER BY `unit` DESC [ RunTime:0.056082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59543833 LIMIT 2 [ RunTime:0.031538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59543833 ORDER BY `minOrder` ASC [ RunTime:0.040364s ]
select * from pdf where partno='TSW-109-07-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028959s ]
SELECT `id` FROM `stock` WHERE `id` <> 59543833 AND `partno` = 'TSW-109-07-S-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182863 [ RunTime:0.012222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59483525 LIMIT 5 [ RunTime:0.008345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59483525 ORDER BY `minOrder` ASC [ RunTime:0.015851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59483525 ORDER BY `unit` DESC [ RunTime:0.026776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59483525 LIMIT 2 [ RunTime:0.014473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59483525 ORDER BY `minOrder` ASC [ RunTime:0.004506s ]
select * from pdf where partno='TSW-109-07-S-S-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-002' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033718s ]
SELECT `id` FROM `stock` WHERE `id` <> 59483525 AND `partno` = 'TSW-109-07-S-S-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.034731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19823283 [ RunTime:0.009592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59482058 LIMIT 5 [ RunTime:0.017463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59482058 ORDER BY `minOrder` ASC [ RunTime:0.028319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59482058 ORDER BY `unit` DESC [ RunTime:0.007848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59482058 LIMIT 2 [ RunTime:0.011541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59482058 ORDER BY `minOrder` ASC [ RunTime:0.023822s ]
select * from pdf where partno='TSW-109-07-S-S-LL-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSW-109-07-S-S-LL-002' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034648s ]
SELECT `id` FROM `stock` WHERE `id` <> 59482058 AND `partno` = 'TSW-109-07-S-S-LL-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19822379 [ RunTime:0.038049s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053642s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042281s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043280s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064417s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049735s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033682s ]
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 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079503s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSW-109-07-S-S%' OR `brand` LIKE 'TSW-109-07-S-S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.079577s ]