SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1794 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1794 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553903,53367,489002,715443,1043733,668562,658621,448301,203317,17198,251074,946986,360132,808260,622385,434371,396568,851620,579742,279456,750745,115259,648495,374415,366796,794279,150961,93816,702265,980259,414970,716485,170055,100328,924990,199620,782296,772406,607692,31911,12844,821605,193181,201488,534802,677779,529143,297707,412805,900854,342260,895636,124119,265999,860230,3617,908534,134883,982826,877209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]