SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101215 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101215 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685254,824809,510789,702054,572986,684069,78147,950759,87943,195461,783400,187682,427608,962390,761410,501822,73684,370322,749126,284579,895940,424404,657744,327869,990921,64871,123222,103938,916312,925335,784368,250085,977874,193444,159206,773970,712710,370624,599198,527388,558576,997290,498260,388331,779434,71459,835815,157073,921456,625193,636175,569678,45018,880576,864963,197984,923588,564189,241684,980973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]