SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012207 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012207 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680923,878606,992647,753925,915422,599300,17608,356075,972190,110194,266167,540645,170662,902931,66234,134277,224524,869318,643778,1018073,488822,471077,218263,152500,555323,524098,535606,936949,8942,1023942,205542,252507,1032168,366062,543906,282930,139441,58790,1011776,61061,333312,47152,59370,130933,85937,966037,810061,148539,192572,235725,535981,75175,164225,314018,166164,601976,587071,582404,997789,124846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]