SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478616 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478616 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322290,503744,932615,171240,752398,416956,398171,333287,272668,125254,727544,767178,791896,1019821,725926,451865,712822,1009440,260455,961320,151519,245102,860355,547107,942461,684015,1013840,289095,891390,20763,198640,325868,471606,891574,287976,328032,258735,626395,276060,57179,680625,929686,889346,938709,389224,965250,125884,683293,253583,476650,911900,789708,601613,1045357,1188,936980,1028353,310594,59532,573727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000714s ]