SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447511 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447511 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251240,606749,90752,75046,372196,673344,114308,735065,195109,337489,797003,898099,125628,96873,373117,797064,477875,586141,10023,231515,843138,421596,133211,394203,532415,983065,822451,923349,408919,667811,305373,399151,803319,424254,1048487,688884,720128,943978,339725,749430,991564,533924,673000,254887,11201,532558,68548,62557,146940,968918,250897,633242,924400,26389,802268,636635,123794,135331,414635,668988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]