SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417246 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417246 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020402,619981,149335,988359,264370,424984,43594,75276,751003,878845,390532,230210,241046,418734,945221,957370,518766,288058,657736,809811,1003253,934992,1035552,992980,191271,603710,267815,797135,493994,666809,1018777,133462,414163,207564,299701,426299,851298,550537,697571,390094,732315,496646,820877,333329,55361,815827,1018028,186531,578555,86865,329446,573139,929627,802225,926749,903697,802643,404901,996064,484741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001881s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]