SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017443 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017443 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564271,252137,740439,1009174,399394,257088,428484,400456,820211,690853,994573,581932,1002125,143233,717317,885144,289226,279404,210019,918761,801619,349520,685201,880840,452472,546963,46873,371122,528518,405593,1004029,317811,547027,555764,568205,674369,818265,182052,966722,847499,996867,920497,58248,489734,960707,22792,78212,414428,547688,402418,637753,527247,96526,394995,588096,225647,872574,122365,771512,425560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]