SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530053 LIMIT 1 [ RunTime:0.000910s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530053 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249126,229287,444643,113641,980870,340865,983791,926058,87502,955393,303649,184672,432832,210704,286863,723236,724865,507339,903000,372006,632523,462363,452936,339517,553666,635244,684957,729924,175535,230620,876627,868611,442320,858487,711887,29495,811846,967126,1044775,940218,558896,390837,269738,590032,894266,94335,547273,916665,1040186,471351,451094,682309,346389,605445,664453,56552,36263,832430,325838,187360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]