SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333841 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333841 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738096,199788,726487,202546,1016453,232337,438884,144379,79131,871306,746630,802073,714925,24285,1039109,493679,366047,970414,874113,124360,605096,362214,409813,202196,792082,306243,522745,351484,37963,838717,502101,780706,850273,264757,79470,371812,791032,56507,556582,1003867,767658,266204,832373,922960,298021,13587,445563,426314,364300,647407,465820,130446,920434,775927,867042,356976,859592,789302,63962,766560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]