SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486511 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486511 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730937,1002677,509828,767211,435760,287637,221782,185673,989843,593189,451159,342531,741267,72453,1020662,72115,969549,762001,108331,648677,553185,300656,177798,648268,277562,147832,274531,309400,79753,844421,449157,545008,835512,159871,645282,156584,879384,873329,117601,15577,586648,156565,619620,308953,535476,183056,559330,494182,125699,833690,301949,158890,238355,545094,1009654,721972,561237,1012969,625309,429652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]