SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320112 LIMIT 1 [ RunTime:0.002414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320112 [ RunTime:0.006798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939837,586487,108262,547136,737697,400346,562679,686486,946573,127673,782439,40415,939372,727092,1016678,56959,26847,870147,1008728,903431,801223,344756,302927,587248,179055,447298,820633,162517,88787,748863,649910,156272,1037452,37510,580159,854890,139858,300357,83577,69776,94211,391501,612143,558139,72303,680253,245885,92153,644043,14245,594814,686193,910883,484737,799117,117820,32202,298711,779404,586937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007812s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]