SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501593 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501593 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438376,17011,133086,101085,991103,441773,999095,632668,143934,613055,206733,298495,896223,856745,786779,420090,180275,441321,169304,707948,750220,244586,620094,897997,736069,271510,799944,253467,910059,806367,94438,217654,233857,467135,501328,693232,1003745,652643,1028778,585880,1040951,8622,312661,914548,122015,769858,889622,794691,182272,510811,429381,302312,773231,340412,266990,739026,311118,902999,226787,288856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]