SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407892 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407892 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186586,583914,835900,548263,901680,91908,594355,647659,418131,795784,322552,503110,909168,1044998,385896,159938,156653,718055,41707,673240,289149,1027258,708079,820091,164898,1020748,943472,883957,703422,156350,702438,559043,139434,10886,403098,1036090,82311,1029395,889320,432778,85809,222865,805476,249555,478401,656273,954249,427601,307996,550151,1003314,113916,460986,1041045,951879,559404,517893,787138,923937,604704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]