SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331688 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331688 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55825,50435,168177,1038548,238382,454800,161066,511913,376585,125757,801520,920168,724772,655734,435987,101061,851336,410643,647650,539209,661408,496535,478533,658970,284298,131100,652018,975825,783285,620747,960734,17034,71344,314824,845704,456536,411260,826138,143095,707899,180242,29281,513302,926028,136264,691347,527135,274672,438445,146324,457478,144003,694858,93534,591583,204884,832520,107492,607144,853018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]