SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351006 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351006 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649470,137960,449194,614114,819389,901525,555529,241479,141616,243506,830123,807862,346192,437007,609235,746265,274125,445805,444914,489040,610996,584952,791653,902355,327113,779915,1037424,1012861,90873,747922,411685,74581,365090,842937,1006754,904816,563987,490446,816114,577868,266070,1027474,730553,436122,207560,12264,814775,35211,152979,1024791,213760,571040,655928,842214,352776,471484,378514,789792,404763,115694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]