SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346075 LIMIT 1 [ RunTime:0.002642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346075 [ RunTime:0.003271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1380,323136,329431,816454,561113,207368,949176,601553,1022772,442470,940178,131673,634447,355579,681122,611921,93635,554313,1030729,367470,209583,531614,53620,391706,1037380,861724,577633,931025,529641,24862,198921,663613,216869,124385,616437,977401,506484,282700,967225,647529,362394,280817,622206,821494,607012,640719,676582,50033,833640,901355,587726,486223,900877,872251,814312,990379,109256,433783,239700,623235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003504s ]