SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28765 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28765 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381658,1007066,606890,558180,10671,340067,505844,492997,88256,471823,198118,270493,869877,154000,442571,425633,554937,775850,1047018,369753,117699,16826,838352,328221,302325,501459,284921,603578,801143,479805,774781,93171,871599,620085,870314,560083,801824,773080,500337,759883,864284,6615,1022633,847229,449533,449455,277011,277347,745867,282155,398586,673915,406386,982503,384541,9057,355220,441403,946901,285697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]