SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311233 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311233 [ RunTime:0.002054s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151992,586842,726818,281914,916034,103884,280543,886867,252609,810337,567035,212126,406612,362626,469168,142935,476714,128696,771405,994178,628976,766675,234511,5901,288386,507540,92372,745001,580579,31879,711873,432177,320174,22569,201769,443166,934748,529055,75212,776878,1043425,220265,336271,159628,472766,949844,561707,873148,601251,160487,108639,328999,742501,710215,1017420,394386,347075,884508,765718,638223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]