SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477314 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477314 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711087,349934,1021217,727024,980800,585132,398985,359934,679003,942633,1048012,729691,229175,183424,135524,253588,190735,784010,613898,642056,54153,97784,405929,745036,836051,629938,13738,743925,903694,961742,502014,898385,325436,87232,77825,798528,725703,293618,411867,443672,216749,863439,572661,862543,939290,647290,837872,75473,20996,840187,548050,835654,983897,853190,1033773,690660,501112,371872,1014722,644144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]