SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808241 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808241 [ RunTime:0.002371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671884,25934,814254,889938,816930,1010559,286014,145218,1017933,195100,768775,949232,560600,732964,801966,925795,625140,916646,1017825,723216,486192,47836,333801,384503,104781,658385,728193,823909,997799,176276,561919,552548,591416,698663,1004326,362436,248431,740677,887745,830680,604136,204186,400614,509577,801901,799624,67384,547774,512378,17920,591468,557598,923194,995776,699166,85485,793974,416917,1021848,80480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]