SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201923 LIMIT 1 [ RunTime:0.001368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201923 [ RunTime:0.001925s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851578,878580,822348,187109,765762,645387,846637,653005,858089,33135,212768,245582,109100,1001022,49303,777291,218131,147343,1033460,919461,164388,542230,285725,528273,1026741,219512,149010,590163,324606,133851,470364,119294,391981,192446,184646,783411,551668,227826,60140,631877,71881,420070,754562,84983,455798,301218,563143,202263,155884,472688,763925,924432,144871,432768,276530,566494,886772,517116,382211,544069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]