SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981073 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981073 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948018,882570,927132,743298,870730,602873,248006,537930,91422,635675,731683,512271,148069,776565,504374,285748,842864,368452,547913,54558,809819,742797,651723,62267,1048338,242139,21504,441359,516113,16517,413139,140972,797068,682981,965474,928894,748095,138135,143482,773094,406615,373843,993774,742174,529467,958754,577719,803689,810548,10715,488975,45915,696425,504117,741622,666779,881685,144337,740073,569578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]