SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541550 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541550 [ RunTime:0.003936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296396,252516,300072,753088,410682,657342,323588,854910,420014,393222,187204,140366,229036,426476,451690,89981,903347,304759,970015,998094,653001,977908,989457,514465,417290,654848,826207,232123,195342,386823,345802,1027515,574996,90800,578069,337055,148083,277018,665125,375051,150979,985251,466595,824715,77036,238036,839649,809393,484373,993569,636716,643995,317839,559747,378472,164165,328747,47586,360662,225401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001423s ]