SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281087 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281087 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329253,585000,944680,783283,442422,71459,148739,124918,360169,547316,214496,590275,437315,926252,672854,618389,1039757,81731,165546,392967,490856,279598,770110,790374,452922,74464,329244,484642,333313,95618,612896,592187,1027722,149800,853253,452957,593470,247516,188492,326552,72932,533168,379767,901955,486360,662178,1045410,666183,185468,7028,860820,39183,94270,227472,205043,400825,431776,895944,585988,338321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]