SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402751 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402751 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584994,917276,709193,303114,32444,382040,561862,447632,280263,201852,374741,284788,414361,231012,381889,1019761,165879,585198,734874,1046287,81989,827838,317019,632689,501630,204410,787729,42500,115961,1041846,77206,362589,128543,438566,803058,1021606,804318,300201,789212,586421,972172,83030,799039,742304,681502,983362,723203,210429,82260,981509,13647,877099,1021578,668606,575724,1017790,121237,836260,546300,442849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]