SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002791s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028514 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028514 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245059,815292,506669,288586,143324,244039,608085,526342,301716,905102,839973,1009059,611145,274058,919174,60728,446779,971721,696867,1031142,850801,519327,349690,275081,773721,469763,248244,555061,783197,525866,117946,584268,1028862,569835,748260,588109,339764,451848,844757,634157,212483,39519,329982,57472,822035,124158,793678,921472,313699,115110,223385,602518,531496,325262,1041955,792387,773641,720392,164584,915553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001910s ]