SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035442 LIMIT 1 [ RunTime:0.001649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035442 [ RunTime:0.002852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980498,420202,641796,346003,143733,50253,823701,1038940,308304,105725,814226,288400,173800,1012664,540018,491925,418829,146387,36182,750071,299147,231381,776676,643646,41594,956577,987088,320136,778864,933072,898482,186301,826627,30948,324891,1039505,460500,276808,524033,788709,715571,737238,926678,743485,1002407,912365,376101,963796,899183,995041,908979,918130,124655,656256,2434,116306,809966,636269,163514,342275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]