SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424796 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424796 [ RunTime:0.002368s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519831,847096,879887,300686,593576,884225,63616,880964,749073,514365,64155,77694,123750,80867,243995,450643,512279,811415,72900,343003,710553,41690,455402,535132,860093,187781,931290,884021,552256,109488,139693,109732,14943,919235,680316,727324,503986,720234,943557,105828,402029,85583,582125,225743,845022,689143,357079,92114,792001,298790,228712,629382,101583,748506,525784,438457,539214,555108,68435,537998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]