SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502985 LIMIT 1 [ RunTime:0.001413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502985 [ RunTime:0.003714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282332,216137,206052,932288,121182,775822,126997,923827,420592,961151,885577,619499,823154,151314,451209,555771,21957,813802,588116,297805,554917,998,16750,898990,490437,343955,305735,447413,717412,1040176,328163,825048,431335,251176,22450,1030637,735348,966914,801405,71983,101587,103385,441694,686316,514011,355006,253187,117265,976882,341016,549778,525104,181861,440256,119377,394197,633743,451391,87854,321999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]