SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43500 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43500 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563269,640029,874346,774939,279390,858626,829340,305671,768564,155574,910514,651725,327431,416477,232504,583016,924797,356181,943303,635129,637879,494073,56479,278749,153062,409353,36790,741851,847239,815026,505065,1045533,370592,343696,147740,408117,621099,443981,900359,848673,85598,146178,1012683,313343,337777,7843,808943,990869,827455,894569,514257,101719,621952,170897,387650,45835,758388,648377,541386,569664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]