SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002654s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016018s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10848275 LIMIT 5 [ RunTime:0.012404s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10848275 ORDER BY `minOrder` ASC [ RunTime:0.005687s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10848275 ORDER BY `unit` DESC [ RunTime:0.004911s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10848275 LIMIT 2 [ RunTime:0.015826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10848275 ORDER BY `minOrder` ASC [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180942 LIMIT 5 [ RunTime:0.003540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180942 ORDER BY `minOrder` ASC [ RunTime:0.009512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17180942 ORDER BY `unit` DESC [ RunTime:0.016701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17180942 LIMIT 2 [ RunTime:0.031558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180942 ORDER BY `minOrder` ASC [ RunTime:0.006855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180938 LIMIT 5 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180938 ORDER BY `minOrder` ASC [ RunTime:0.016139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17180938 ORDER BY `unit` DESC [ RunTime:0.006016s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17180938 LIMIT 2 [ RunTime:0.008569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180938 ORDER BY `minOrder` ASC [ RunTime:0.005183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180935 LIMIT 5 [ RunTime:0.021204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180935 ORDER BY `minOrder` ASC [ RunTime:0.022156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17180935 ORDER BY `unit` DESC [ RunTime:0.013216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17180935 LIMIT 2 [ RunTime:0.000940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180935 ORDER BY `minOrder` ASC [ RunTime:0.003950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180934 LIMIT 5 [ RunTime:0.009908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180934 ORDER BY `minOrder` ASC [ RunTime:0.013946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17180934 ORDER BY `unit` DESC [ RunTime:0.008196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17180934 LIMIT 2 [ RunTime:0.008675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180934 ORDER BY `minOrder` ASC [ RunTime:0.006226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180931 LIMIT 5 [ RunTime:0.008360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180931 ORDER BY `minOrder` ASC [ RunTime:0.006009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17180931 ORDER BY `unit` DESC [ RunTime:0.008943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17180931 LIMIT 2 [ RunTime:0.004438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180931 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15383106 LIMIT 5 [ RunTime:0.001172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15383106 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15383106 ORDER BY `unit` DESC [ RunTime:0.004046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15383106 LIMIT 2 [ RunTime:0.006042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15383106 ORDER BY `minOrder` ASC [ RunTime:0.012317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15383105 LIMIT 5 [ RunTime:0.040503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15383105 ORDER BY `minOrder` ASC [ RunTime:0.003504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15383105 ORDER BY `unit` DESC [ RunTime:0.001428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15383105 LIMIT 2 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15383105 ORDER BY `minOrder` ASC [ RunTime:0.002118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299258 LIMIT 5 [ RunTime:0.024287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299258 ORDER BY `minOrder` ASC [ RunTime:0.007941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299258 ORDER BY `unit` DESC [ RunTime:0.009516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299258 LIMIT 2 [ RunTime:0.016931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299258 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299248 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299248 ORDER BY `minOrder` ASC [ RunTime:0.014876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299248 ORDER BY `unit` DESC [ RunTime:0.014091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299248 LIMIT 2 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299248 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299245 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299245 ORDER BY `minOrder` ASC [ RunTime:0.007843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299245 ORDER BY `unit` DESC [ RunTime:0.023861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299245 LIMIT 2 [ RunTime:0.002783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299245 ORDER BY `minOrder` ASC [ RunTime:0.017108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299242 LIMIT 5 [ RunTime:0.014417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299242 ORDER BY `minOrder` ASC [ RunTime:0.012574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299242 ORDER BY `unit` DESC [ RunTime:0.001595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299242 LIMIT 2 [ RunTime:0.005966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299242 ORDER BY `minOrder` ASC [ RunTime:0.014250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299240 LIMIT 5 [ RunTime:0.009677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299240 ORDER BY `minOrder` ASC [ RunTime:0.008324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299240 ORDER BY `unit` DESC [ RunTime:0.024482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299240 LIMIT 2 [ RunTime:0.011197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299240 ORDER BY `minOrder` ASC [ RunTime:0.028334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299226 LIMIT 5 [ RunTime:0.016401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299226 ORDER BY `minOrder` ASC [ RunTime:0.014459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299226 ORDER BY `unit` DESC [ RunTime:0.021353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299226 LIMIT 2 [ RunTime:0.020117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299226 ORDER BY `minOrder` ASC [ RunTime:0.004353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299225 LIMIT 5 [ RunTime:0.012463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299225 ORDER BY `minOrder` ASC [ RunTime:0.013433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299225 ORDER BY `unit` DESC [ RunTime:0.009633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299225 LIMIT 2 [ RunTime:0.012940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299225 ORDER BY `minOrder` ASC [ RunTime:0.038234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299222 LIMIT 5 [ RunTime:0.039384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299222 ORDER BY `minOrder` ASC [ RunTime:0.039001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299222 ORDER BY `unit` DESC [ RunTime:0.033618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299222 LIMIT 2 [ RunTime:0.040572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299222 ORDER BY `minOrder` ASC [ RunTime:0.027966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299221 LIMIT 5 [ RunTime:0.033657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299221 ORDER BY `minOrder` ASC [ RunTime:0.025542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299221 ORDER BY `unit` DESC [ RunTime:0.013470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299221 LIMIT 2 [ RunTime:0.021001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299221 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299218 LIMIT 5 [ RunTime:0.035206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299218 ORDER BY `minOrder` ASC [ RunTime:0.077559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12299218 ORDER BY `unit` DESC [ RunTime:0.038525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12299218 LIMIT 2 [ RunTime:0.038346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12299218 ORDER BY `minOrder` ASC [ RunTime:0.011828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12277371 LIMIT 5 [ RunTime:0.026883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12277371 ORDER BY `minOrder` ASC [ RunTime:0.076897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12277371 ORDER BY `unit` DESC [ RunTime:0.041505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12277371 LIMIT 2 [ RunTime:0.050213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12277371 ORDER BY `minOrder` ASC [ RunTime:0.018534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11271976 LIMIT 5 [ RunTime:0.014610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11271976 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11271976 ORDER BY `unit` DESC [ RunTime:0.017564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11271976 LIMIT 2 [ RunTime:0.039543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11271976 ORDER BY `minOrder` ASC [ RunTime:0.003956s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014749s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61144003 LIMIT 5 [ RunTime:0.001602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144003 ORDER BY `minOrder` ASC [ RunTime:0.004880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61144003 ORDER BY `unit` DESC [ RunTime:0.000811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61144003 LIMIT 2 [ RunTime:0.002656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61144003 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
select * from pdf where partno='SA3243' and brandshort='Bulgin' limit 1 [ RunTime:0.005256s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA3243' OR `brand` LIKE 'Bulgin%' ) ) LIMIT 1 [ RunTime:0.006436s ]
SELECT `id` FROM `stock` WHERE `id` <> 61144003 AND `partno` = 'SA3243' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin%' ) [ RunTime:0.011841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10848275 [ RunTime:0.012292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 47336477 LIMIT 5 [ RunTime:0.043446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 47336477 ORDER BY `minOrder` ASC [ RunTime:0.005107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 47336477 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 47336477 LIMIT 2 [ RunTime:0.003570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 47336477 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
select * from pdf where partno='SA3243' and brandshort='L-com' limit 1 [ RunTime:0.010075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA3243' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.002244s ]
SELECT `id` FROM `stock` WHERE `id` <> 47336477 AND `partno` = 'SA3243' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.007942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34480910 [ RunTime:0.006152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42857865 LIMIT 5 [ RunTime:0.013490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42857865 ORDER BY `minOrder` ASC [ RunTime:0.004133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42857865 ORDER BY `unit` DESC [ RunTime:0.003174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42857865 LIMIT 2 [ RunTime:0.008841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42857865 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
select * from pdf where partno='SA324374F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.002481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324374F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.001704s ]
SELECT `id` FROM `stock` WHERE `id` <> 42857865 AND `partno` = 'SA324374F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299248 [ RunTime:0.001267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42857635 LIMIT 5 [ RunTime:0.007910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42857635 ORDER BY `minOrder` ASC [ RunTime:0.003239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42857635 ORDER BY `unit` DESC [ RunTime:0.032396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42857635 LIMIT 2 [ RunTime:0.032272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42857635 ORDER BY `minOrder` ASC [ RunTime:0.013895s ]
select * from pdf where partno='SA324374F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.006312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324374F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.009402s ]
SELECT `id` FROM `stock` WHERE `id` <> 42857635 AND `partno` = 'SA324374F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.022143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299248 [ RunTime:0.009238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42849455 LIMIT 5 [ RunTime:0.031696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42849455 ORDER BY `minOrder` ASC [ RunTime:0.030202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42849455 ORDER BY `unit` DESC [ RunTime:0.011846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42849455 LIMIT 2 [ RunTime:0.050217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42849455 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='SA324353F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.007601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324353F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.047741s ]
SELECT `id` FROM `stock` WHERE `id` <> 42849455 AND `partno` = 'SA324353F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.151906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299240 [ RunTime:0.036096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42813306 LIMIT 5 [ RunTime:0.068090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42813306 ORDER BY `minOrder` ASC [ RunTime:0.037511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42813306 ORDER BY `unit` DESC [ RunTime:0.048597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42813306 LIMIT 2 [ RunTime:0.063950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42813306 ORDER BY `minOrder` ASC [ RunTime:0.035959s ]
select * from pdf where partno='SA324360F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.078211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324360F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.022371s ]
SELECT `id` FROM `stock` WHERE `id` <> 42813306 AND `partno` = 'SA324360F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.023552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11271973 [ RunTime:0.026312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42813303 LIMIT 5 [ RunTime:0.047428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42813303 ORDER BY `minOrder` ASC [ RunTime:0.058842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42813303 ORDER BY `unit` DESC [ RunTime:0.034923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42813303 LIMIT 2 [ RunTime:0.012580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42813303 ORDER BY `minOrder` ASC [ RunTime:0.012037s ]
select * from pdf where partno='SA324375F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.023379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324375F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.015667s ]
SELECT `id` FROM `stock` WHERE `id` <> 42813303 AND `partno` = 'SA324375F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.030112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299218 [ RunTime:0.050461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42736163 LIMIT 5 [ RunTime:0.011428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42736163 ORDER BY `minOrder` ASC [ RunTime:0.086460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42736163 ORDER BY `unit` DESC [ RunTime:0.033311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42736163 LIMIT 2 [ RunTime:0.020391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42736163 ORDER BY `minOrder` ASC [ RunTime:0.011867s ]
select * from pdf where partno='SA324380F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.011311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324380F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.003106s ]
SELECT `id` FROM `stock` WHERE `id` <> 42736163 AND `partno` = 'SA324380F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.069309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299258 [ RunTime:0.051050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42667635 LIMIT 5 [ RunTime:0.022636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42667635 ORDER BY `minOrder` ASC [ RunTime:0.062357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42667635 ORDER BY `unit` DESC [ RunTime:0.050802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42667635 LIMIT 2 [ RunTime:0.050815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42667635 ORDER BY `minOrder` ASC [ RunTime:0.050882s ]
select * from pdf where partno='SA324333F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.051669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324333F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.050960s ]
SELECT `id` FROM `stock` WHERE `id` <> 42667635 AND `partno` = 'SA324333F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.051091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180934 [ RunTime:0.025212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42667634 LIMIT 5 [ RunTime:0.001800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42667634 ORDER BY `minOrder` ASC [ RunTime:0.022649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42667634 ORDER BY `unit` DESC [ RunTime:0.000818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42667634 LIMIT 2 [ RunTime:0.007353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42667634 ORDER BY `minOrder` ASC [ RunTime:0.004696s ]
select * from pdf where partno='SA32433EF35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.005574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA32433EF35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.000910s ]
SELECT `id` FROM `stock` WHERE `id` <> 42667634 AND `partno` = 'SA32433EF35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.013684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299226 [ RunTime:0.008457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42667633 LIMIT 5 [ RunTime:0.001617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42667633 ORDER BY `minOrder` ASC [ RunTime:0.015366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42667633 ORDER BY `unit` DESC [ RunTime:0.028607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42667633 LIMIT 2 [ RunTime:0.032830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42667633 ORDER BY `minOrder` ASC [ RunTime:0.047846s ]
select * from pdf where partno='SA324312F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.019724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324312F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.009564s ]
SELECT `id` FROM `stock` WHERE `id` <> 42667633 AND `partno` = 'SA324312F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.034521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299225 [ RunTime:0.014484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42651270 LIMIT 5 [ RunTime:0.038256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42651270 ORDER BY `minOrder` ASC [ RunTime:0.044268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42651270 ORDER BY `unit` DESC [ RunTime:0.007635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42651270 LIMIT 2 [ RunTime:0.042814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42651270 ORDER BY `minOrder` ASC [ RunTime:0.083860s ]
select * from pdf where partno='SA324300F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.030406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324300F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.016543s ]
SELECT `id` FROM `stock` WHERE `id` <> 42651270 AND `partno` = 'SA324300F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.064646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15383106 [ RunTime:0.020236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42651260 LIMIT 5 [ RunTime:0.096403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42651260 ORDER BY `minOrder` ASC [ RunTime:0.046902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42651260 ORDER BY `unit` DESC [ RunTime:0.069515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42651260 LIMIT 2 [ RunTime:0.033532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42651260 ORDER BY `minOrder` ASC [ RunTime:0.036023s ]
select * from pdf where partno='SA324307F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.063426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324307F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.054514s ]
SELECT `id` FROM `stock` WHERE `id` <> 42651260 AND `partno` = 'SA324307F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.018430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299221 [ RunTime:0.027682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42634526 LIMIT 5 [ RunTime:0.005943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42634526 ORDER BY `minOrder` ASC [ RunTime:0.018352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42634526 ORDER BY `unit` DESC [ RunTime:0.008808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42634526 LIMIT 2 [ RunTime:0.012770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42634526 ORDER BY `minOrder` ASC [ RunTime:0.009714s ]
select * from pdf where partno='SA324320F36MAR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.002213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324320F36MAR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.003905s ]
SELECT `id` FROM `stock` WHERE `id` <> 42634526 AND `partno` = 'SA324320F36MAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.007664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12277371 [ RunTime:0.008445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42632452 LIMIT 5 [ RunTime:0.006398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42632452 ORDER BY `minOrder` ASC [ RunTime:0.003213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42632452 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42632452 LIMIT 2 [ RunTime:0.007346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42632452 ORDER BY `minOrder` ASC [ RunTime:0.008244s ]
select * from pdf where partno='SA32439AF35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.011447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA32439AF35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.005407s ]
SELECT `id` FROM `stock` WHERE `id` <> 42632452 AND `partno` = 'SA32439AF35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11271975 [ RunTime:0.003966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42632449 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42632449 ORDER BY `minOrder` ASC [ RunTime:0.002623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42632449 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42632449 LIMIT 2 [ RunTime:0.002172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42632449 ORDER BY `minOrder` ASC [ RunTime:0.002049s ]
select * from pdf where partno='SA324304F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.001246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324304F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.001869s ]
SELECT `id` FROM `stock` WHERE `id` <> 42632449 AND `partno` = 'SA324304F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180942 [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42632448 LIMIT 5 [ RunTime:0.000537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42632448 ORDER BY `minOrder` ASC [ RunTime:0.002612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42632448 ORDER BY `unit` DESC [ RunTime:0.000548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42632448 LIMIT 2 [ RunTime:0.002185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42632448 ORDER BY `minOrder` ASC [ RunTime:0.002036s ]
select * from pdf where partno='SA324330F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.002532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324330F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.003710s ]
SELECT `id` FROM `stock` WHERE `id` <> 42632448 AND `partno` = 'SA324330F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180931 [ RunTime:0.007251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42626270 LIMIT 5 [ RunTime:0.004179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42626270 ORDER BY `minOrder` ASC [ RunTime:0.011069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42626270 ORDER BY `unit` DESC [ RunTime:0.013205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42626270 LIMIT 2 [ RunTime:0.026621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42626270 ORDER BY `minOrder` ASC [ RunTime:0.001516s ]
select * from pdf where partno='SA324338F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.005064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324338F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.002642s ]
SELECT `id` FROM `stock` WHERE `id` <> 42626270 AND `partno` = 'SA324338F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.005695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299242 [ RunTime:0.002591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42622761 LIMIT 5 [ RunTime:0.002922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42622761 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42622761 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42622761 LIMIT 2 [ RunTime:0.002057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42622761 ORDER BY `minOrder` ASC [ RunTime:0.001897s ]
select * from pdf where partno='SA32433AF35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.004792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA32433AF35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.000983s ]
SELECT `id` FROM `stock` WHERE `id` <> 42622761 AND `partno` = 'SA32433AF35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.002077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12299222 [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42619327 LIMIT 5 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42619327 ORDER BY `minOrder` ASC [ RunTime:0.004291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42619327 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42619327 LIMIT 2 [ RunTime:0.005232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42619327 ORDER BY `minOrder` ASC [ RunTime:0.001848s ]
select * from pdf where partno='SA324320F35HLR' and brandshort='CTS-Frequency Controls' limit 1 [ RunTime:0.003559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SA324320F35HLR' OR `brand` LIKE 'CTS-Frequency Controls%' ) ) LIMIT 1 [ RunTime:0.001147s ]
SELECT `id` FROM `stock` WHERE `id` <> 42619327 AND `partno` = 'SA324320F35HLR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cts-frequency controls%' ) [ RunTime:0.003084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15383105 [ RunTime:0.000371s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000957s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000624s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000584s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000597s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000608s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000584s ]
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 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000796s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SA3243%' OR `brand` LIKE 'SA3243%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000873s ]