SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413816 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413816 [ RunTime:0.002835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292117,211334,404065,156176,978912,179969,526929,709141,118540,158709,371038,939348,299430,693726,60287,689937,881504,1034082,342122,558860,398624,475785,506381,13171,735929,430118,669663,521603,412302,471436,834860,795942,838389,409214,127393,11855,576367,249196,1043710,469153,811406,296037,138360,687510,20010,841200,1011827,792068,302128,198013,671527,274888,306921,891442,906055,177607,909449,530742,448331,466791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]