SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423638 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423638 [ RunTime:0.002411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345246,286718,336944,922095,403537,463662,250980,341263,148876,624612,454212,532868,145763,83974,320529,287625,21656,1020260,892073,606250,819965,701593,996780,118138,539565,323679,309848,462802,683584,268908,305212,572880,24001,195588,746735,160781,501029,821012,529169,172880,914787,615267,177132,446949,787406,684583,52037,636712,730396,554204,264765,655729,520409,116462,616382,295964,850458,803513,594949,429100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002710s ]