SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267612 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267612 [ RunTime:0.003627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530896,507318,473849,975583,46063,853624,340647,80094,152506,800113,264421,695886,352948,742771,161910,457428,795628,209909,245083,149913,559284,554298,188009,327018,595805,110875,887130,922226,379058,831710,242259,55399,1019702,805301,941828,145146,698286,998233,366027,565564,139566,236496,175886,443410,222566,679360,512829,476341,638689,828254,172452,643566,499827,104704,9321,425520,292102,367592,56980,514139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]