SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310121 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310121 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674573,61566,605649,786389,685353,945797,606603,816725,463746,719105,888338,279384,288359,1040789,275752,500897,853844,335369,151041,227936,715354,212773,656918,513869,360593,681707,781553,382910,483299,390308,745299,54109,537444,370547,741695,169708,34733,383847,819988,612524,216142,418034,632607,727209,395543,602146,1008629,627840,479499,530772,874757,298003,922157,154517,145374,199941,550296,915961,541879,145505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]