SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043327 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043327 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621176,38603,742373,400897,132247,925065,875246,498596,120745,206934,1028305,30338,778629,48066,592657,2757,234189,420450,788623,79428,673769,1008182,988317,251523,376060,385758,427118,609082,147339,613996,457855,236363,898182,704882,890291,968332,562454,746836,536954,560185,1013315,31054,146558,751321,729169,45001,872857,444922,973001,686326,884747,4636,167270,522801,879315,710533,113068,993428,785136,397191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]