SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489410 LIMIT 1 [ RunTime:0.000854s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489410 [ RunTime:0.003719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (973023,201184,4270,843928,472646,350389,285878,790810,650570,52283,298182,807413,677919,57153,20040,10928,278899,150667,1032709,4544,1018230,697565,493180,879572,900109,59343,839588,647865,125431,517213,434889,200481,869632,203868,278688,600941,601365,186166,637348,945471,964648,241781,159119,840658,456478,756701,660255,976757,585174,177051,284015,464208,254548,371101,789720,555293,620639,351902,65101,150443) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]