SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423271 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423271 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907091,807170,283736,135387,1012133,3238,150181,640404,932558,896135,66428,325970,726576,635318,365069,33070,153617,246512,944653,658571,362867,534369,604184,726436,671328,137524,688555,862935,735436,638367,370817,206505,940180,1030023,176093,1014791,663808,39026,131278,989790,483920,403297,248058,837230,889028,70249,168037,439946,806600,458473,573605,732587,182007,1036334,635145,413061,169233,835600,189506,342937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]