SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995081 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995081 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599943,227075,871426,785058,491306,702015,593564,956570,479720,747772,1007738,383117,279326,143099,681761,214487,989506,164576,52067,756537,291212,616051,680552,767631,292878,423062,967180,103514,751100,705432,280035,126014,370553,495095,626750,1034978,514175,559297,388306,1026865,837140,424250,839871,314814,388911,520106,907137,155527,110030,896691,17432,140069,846890,895705,769242,544977,107272,230610,470559,82553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]