SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409293 LIMIT 1 [ RunTime:0.001932s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409293 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365089,209358,282948,811040,845042,867016,665012,286007,238754,559890,963767,501820,913064,212446,688903,924265,548638,249454,268404,329628,45652,36711,365730,125018,214354,685507,623918,253365,549197,466994,430060,771915,125123,206027,755960,154950,971188,112635,523256,524429,634029,831587,143054,610760,356008,169303,835272,619141,60464,232582,290896,307923,733822,787295,973937,63960,482335,155001,614607,807953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]