SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010117 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010117 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372116,738069,403957,329716,40332,205154,415524,147692,494021,1005163,268354,737585,802240,44162,301709,535288,422804,82423,448255,393357,49084,817328,186578,96166,249358,404057,303703,261705,664802,191484,150667,597471,43016,601883,655473,228948,753461,750971,35895,1034767,164584,466171,302765,995391,515096,306900,263091,530762,540232,669738,419776,939384,993237,923324,392855,415494,397314,137088,628115,165817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]