SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014822 LIMIT 1 [ RunTime:0.000871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014822 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229217,16884,349184,977182,196261,718862,429174,422695,561948,658514,71623,113895,881649,541748,232648,841039,737388,573260,391911,734567,901593,61959,886648,113513,754200,24742,345126,723634,300056,591062,584187,14066,339304,59058,155290,504290,238163,871584,7828,954976,621409,890850,606581,817125,782983,211405,773318,962647,221917,457899,793629,24750,974831,436659,205331,106871,268300,847614,452099,388475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]