SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804816 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804816 [ RunTime:0.003929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (767637,118646,134778,919174,615337,870950,536259,1026859,283548,771989,1043288,344005,690068,175383,675855,220347,124381,629568,316083,805209,1036714,1009146,576361,760287,251729,917635,608526,370786,479540,352108,631246,809460,931580,562908,322800,113824,294648,1024092,708413,788488,1042958,45790,970024,483690,342811,698350,67531,103382,228272,148280,950660,385009,820879,672073,660870,215777,172978,653326,141540,488949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]