SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370846 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370846 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611314,222757,191713,554882,508222,1035633,826100,196955,835027,231648,859732,265751,985899,461326,386018,763347,775449,414643,503472,818473,181927,179788,552066,135572,23563,568688,6090,145276,509160,182831,113582,363385,1042463,310902,788627,974299,103353,950852,106333,204639,527504,680632,764469,242366,426099,651587,221251,711776,764892,527554,742321,469669,516170,281047,816377,971535,373336,423388,167402,364922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]