SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016318 LIMIT 1 [ RunTime:0.001500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016318 [ RunTime:0.002822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376216,108711,338666,141309,884037,737673,250624,719135,45959,142483,919829,409124,221809,189446,41021,506334,162146,910510,887618,71866,633200,1019104,601774,938255,244031,335791,913005,229992,232179,94522,300291,318909,297188,753838,807245,609975,333065,948421,533742,714020,813464,451028,1009465,56402,233059,17049,643806,541750,923785,298941,482616,360416,308147,952541,192688,133025,648208,931706,1010368,320220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]