SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506181 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506181 [ RunTime:0.002607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292594,336022,944381,956611,997867,806332,850343,48511,710337,317200,604668,290605,690315,295617,842935,184189,516968,870412,739042,196509,567464,1010101,1041536,65788,686383,569576,808196,372798,853343,266656,228932,876474,125628,949090,595875,189237,692478,972834,770089,700233,833321,656124,771508,425183,143308,124439,514406,893183,513353,964075,35973,101084,267858,640298,352512,232120,31587,940075,239307,259260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]