SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417083 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417083 [ RunTime:0.003626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776648,49379,932709,329806,774236,401629,630712,954558,867106,256138,449864,447193,1005137,380427,472056,573585,748035,109362,736134,664647,583401,818326,763651,123246,318920,1018156,57679,296902,752086,411773,167109,898593,875901,616961,198018,533921,361277,258807,759481,701976,543504,485201,70095,501714,496695,925102,498612,890073,59,332551,639124,971023,317486,20074,281467,546987,211557,129013,545799,790768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]