SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510018 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510018 [ RunTime:0.001371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324547,143970,235286,119958,807207,306110,991891,260654,741800,921105,31340,936544,239313,1032731,832008,44507,455038,117300,941165,937303,619598,1021745,191869,758168,683746,706322,113121,216170,772109,44122,422033,82612,687717,755288,1003462,393282,731807,5171,305822,1010977,511592,710485,75589,401725,1011881,25317,889647,413823,864388,331713,367128,510743,1031991,241529,273521,835601,950592,422320,819245,668108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]