SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522648 LIMIT 1 [ RunTime:0.000863s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522648 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033115,881024,239299,466250,627183,489191,363690,75833,735775,499965,208701,1037514,11204,229400,719612,123593,240600,564149,216985,528344,496177,475941,399184,954434,1040231,508674,579139,465545,581022,500481,573284,286813,836793,613402,160509,525650,178980,557804,452898,919504,435198,746890,27084,447572,989062,854842,361771,932149,735468,44417,420691,549521,404153,917675,780041,666627,348412,407847,146016,7252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002341s ]