SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001887s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457716 LIMIT 1 [ RunTime:0.001614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457716 [ RunTime:0.003247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601748,135659,961764,540859,179595,174622,434610,570940,161024,184603,816432,195202,415233,885973,445913,682542,96766,900854,948551,732007,179812,504878,565271,815510,427889,252697,798792,69817,845184,630236,71568,234914,121651,407831,419562,550967,922596,103799,861312,46088,777669,106706,634165,355526,689850,674809,407746,607846,430942,53606,986904,630233,459447,301686,416136,248761,484397,207196,719916,704062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001689s ]