SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458244 LIMIT 1 [ RunTime:0.002846s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458244 [ RunTime:0.003223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280202,401107,207919,469820,888766,263334,912158,700086,938861,214601,920104,486197,701865,430036,364900,834524,494943,246806,830909,613547,373600,871120,300661,751084,102448,503529,450431,252434,841782,363902,334839,96656,911119,25155,1031407,722600,269191,906896,813245,699212,794971,393465,873928,645349,626026,396898,756501,537485,896157,643907,872327,491151,1042310,108793,208453,50867,953840,314154,532997,478269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]